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 “allovers” 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.

189 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
allovers113767(None) 
allover1038581allover_
alcoves1297872alcove_s
allayers11156632allayers
allegers9378232allegers
allobars1046582allobars
allotters965562allotters
allurers8286772allurers
almoners1068132almoners
balloters1157672balloters
clovers125114662_clovers
flyovers1733672flyovers
gallopers12136322gallopers
glovers114310882_glovers
hallowers15137722hallowers
layovers1434072layovers
lovers94223432__lovers
plovers123611832_plovers
pullovers14124242pullovers
rollovers1244092rollovers
walkovers1942612walkovers
wallopers14136272wallopers
wallowers15127652wallowers
aboves114512843a_bove_s
absolvers1443123absolvers
adorers84411723a_dorers
aivers94822323a__ivers
alcove1178083alcove__
alcoved1375613alcove_d
alders74218423a_l_ders
aldoses8311203aldose_s
algors7312553algo__rs
alieners889823alieners
aligners9117563aligners
aliners74717723a_liners
allayer10148213allayer_
allees64521483all__ees
alleger8319623alleger_
alleges84212563allege_s
alleles73812033allele_s
alleys95113303all__eys
allies63827673all_ie_s
allobar946663allobar_
allods73615083allo__ds
allometry1445183allometry
allonges937313allonges
allonyms1344363allonyms
allosaurs9134153allosaurs
allostery1243723allostery
allots64019173allo__ts
allottees964323allottees
allotter866473allotter_
allowed111610073allowe_d
allows94517683allo__ws
alloxans1545243alloxans
alloyed11158033alloye_d
alloys94014563allo__ys
allseeds943393allseeds
alludes83610333allude_s
allurer7348433allurer_
allures72913113allure_s
almners9399563a_lmners
almoner949383almoner_
aloes54933673a_lo_e_s
alterers82512493alterers
alters64924223a_l_ters
annoyers1185033annoyers
apposers1236283apposers
approvers16104913approvers
armorers10288963armorers
arrivers11137003arrivers
atoners75013953a_toners
avers85127313a___vers
avowers1336333a_vowers
ballers94421013ball__ers
ballonets1146723ballonets
balloter1078893balloter_
bellowers14177623bellowers
beloveds14153963beloveds
bloomers12348823bloomers
bloopers12397373bloopers
blowers124313593_blowers
boilovers1444103boilovers
callers94221963call__ers
callipers1356493callipers
calloses10313383callose_s
callower13159073callower_
caloyers1337343caloyers
clavers124314893_clavers
cleavers13398863cleavers
clivers123411753_clivers
cloners94514823_cloners
closers94415313_closers
clover114617123_clover_
clovery15407403_clovery
cloves114918823_clove_s
colorers10312183colorers
covers114627963__covers
culvers12329823cul_vers
cutovers1335113cutovers
dalliers93610613dall_iers
delivers123310753delivers
delvers113411993del_vers
drovers115212643_drovers
elopers95112943_elopers
elvers93814983_el_vers
estovers1136453estovers
evolvers14264773evolvers
falconers1445323falconers
fallers103917993fall__ers
flivvers1733113flivvers
flooders12257833flooders
floorers11227573floorers
flopovers1742563flopovers
flowers133413173_flowers
flyover1633513flyover_
followers15146183followers
galloper11137183galloper_
glover104513533_glover_
gloves104115183_glove_s
glowers113412093_glowers
groovers12337123groovers
halloes104021513hallo_e_s
hallower14139813hallower_
halvers133311423hal_vers
handovers16136183handovers
hangovers16144153hangovers
holdovers1643763holdovers
hoovers134312703_hoovers
hovers124320253__hovers
laborers10208383laborers
lavers94526363__lavers
layover1334433layover_
leavers103717783_leavers
levers94621323__levers
livers94927823__livers
lollers72713793_lollers
loners64225803__loners
lookers114014073_lookers
loopers93914033_loopers
looters74419163_looters
lopers84424143__lopers
losers65123583__losers
louvers10359103_louvers
lover85526453__lover_
loves85332013__love_s
lowers94624923__lowers
makeovers18103283makeovers
movers115117193__movers
overs85224793___overs
palavers1337993palavers
pallors9314343pallo__rs
passovers14144753passovers
plover115312613_plover_
plowers123812243_plowers
popovers1595663popovers
provers123817793_provers
pullover13134643pullover_
ralliers84010833rall_iers
recovers133511123recovers
removers13449223removers
rollover1144453rollover_
rovers95423523__rovers
runovers1134473runovers
salliers83613333sall_iers
sallower11139503sallower_
salvers103916003sal_vers
scallopers1454043scallopers
shovers134612993_shovers
silvers104714033sil_vers
slalomers1144553slalomers
slavers103716503_slavers
slipovers1443463slipovers
slivers104115253_slivers
slopers94213093_slopers
slovens10316573_slovens
solvers104414253sol_vers
spillovers1542393spillovers
stovers103713733_stovers
swallowers1653813swallowers
takeovers1683193takeovers
talliers83711363tall_iers
trovers103713313_trovers
uncovers1336573uncovers
walkover1842943walkover_
walloper13147113walloper_
wallower14158933wallower_
willowers15166693willowers
wolvers13349313wol_vers

Search took 9 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.1561145455.1
2DLD Change Limit1461621898.25017716.6
3Display Results1891890.0802362.5
 (SQL Overall)1786911898.48621057.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.