Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “layovers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

153 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
layovers143407(None) 
layover1334431layover_
allovers1137672allovers
flyovers1733672flyovers
laborers10208382laborers
lavers94526362la__vers
layers93921182lay__ers
lovers94223432l__overs
aboves114512843_above_s
adorers84411733_adorers
aivers94822323_a_ivers
alcoves1297883alcove_s
allover1038583allover_
almoners1068133almoners
atoners75013953_atoners
avers85127313_a__vers
avowers1336333_avowers
bayonets13135583bayonets
blazoners2043863blazoners
cadavers1435893cadavers
cajolers17267133cajolers
caloyers1337343caloyers
canoers94318373cano_ers
carolers103314173carolers
carryovers1842513carryovers
carvers124817543ca_rvers
cavers115026843ca__vers
clamorers1345783clamorers
clavers124314903cla__vers
clovers125114663_clovers
covers114627963__covers
crayoners1444503crayoners
cutovers1335123cutovers
drovers115212643_drovers
estovers1136453estovers
fagoters1234863fagoters
favorers1465493favorers
flashovers1952813flashovers
flavorers1563983flavorers
flayers133912033flay__ers
flopovers1742563flopovers
flyover1633513flyover_
gaolers83511563ga_olers
glovers114310883_glovers
groovers12337123groovers
halvers133311423ha_lvers
handovers16136183handovers
hangovers16144163hangovers
havers124721483ha__vers
hayers124415943hay__ers
hoovers134312703_hoovers
hovers124320253__hovers
jayvees2052923jay_vees
kayakers1463613kayakers
kayoes134710823kayo_e_s
laagers83411253la_agers
labelers10249413labelers
laborer9249513laborer_
labors84016413labo__rs
labourers1144713labourers
labours9349893labo_urs
lacers85225253la__cers
lackers134120543la_ckers
lacquers19125033lacquers
ladders94115173la_dders
laders74927763la__ders
ladlers84613573la_dlers
ladyloves1641793ladylove_s
lagers74826143la__gers
laggers94216243la_ggers
lakers105225153la__kers
lambers113817113la_mbers
lampers113817333la_mpers
lamsters1099753lamsters
lancers93616643la_ncers
lanciers10308543lanciers
landers84026213la_nders
landlers94312833landlers
lanners73618333la_nners
lappers113717463la_ppers
lapsers93911053la_psers
larders83516943la_rders
larkers113014513la_rkers
lasers64925703la__sers
lashers104121833la_shers
lassoers8338513lassoers
lasters75627693la_sters
lathers104321883la_thers
lauders84012893la_uders
laughers1235923laughers
launders9358743launders
laveers10329363la_veers
laver85031793la__ver_
laves86039153la__ve_s
lawgivers1641793lawgivers
lawyers13377153la_wyers
layer84626473lay__er_
layoffs1642573layo_ffs
layouts1046483layo_uts
leavers103717783l_eavers
leftovers1542783leftovers
levers94621323l__evers
livers94927823l__ivers
loners64225813l__oners
lookers114014073l_ookers
loopers93914033l_oopers
looters74419163l_ooters
lopers84424143l__opers
losers65123583l__osers
louvers10359103l_ouvers
lover85526453l__over_
loves85332013l__ove_s
lowers94624923l__owers
makeovers18103283makeovers
mayoress1344383mayoress
mayors115714193mayo__rs
movers115117193__movers
overs85224793___overs
palavers1337993palavers
passovers14144753passovers
pavers115021823pa__vers
payers114621823pay__ers
payors114312643payo__rs
players124313763play__ers
playgoers1543193playgoers
plovers123611833_plovers
popovers1595663popovers
provers123817793_provers
ravers94628183ra__vers
recovers133511123recovers
removers13449223removers
rovers95423523__rovers
runovers1134473runovers
salvers103916003sa_lvers
samovars1343703samovars
savers93825923sa__vers
savorers1157223savorers
sayers94221593say__ers
shovers134613003_shovers
slalomers1144553slalomers
slavers103716503sla__vers
slayers104513323slay__ers
slipovers1443463slipovers
stovers103713733_stovers
taborers10268333taborers
takeovers1683193takeovers
trovers103713323_trovers
uncovers1336573uncovers
vaporers1336243vaporers
wagoners1235473wagoners
waivers133410053wa_ivers
walkovers1942613walkovers
wavers125022473wa__vers

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.440406115.9
2DLD Change Limit1461621536.75021653.6
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.25024647.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.