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

245 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
allover103858(None) 
allovers1137671allovers
alcove1178082alcove_
alcoved1375612alcoved
alcoves1297872alcoves
allayer10148212allayer
alleger8319622alleger
allobar946662allobar
allotter866472allotter
allowed111610072allowed
alloyed11158032alloyed
allurer7348432allurer
almoner949382almoner
balloter1078892balloter
callower13159072callower
clover114617122_clover
flyover1633512flyover
galloper11137182galloper
glover104513532_glover
hallower14139812hallower
layover1334432layover
lover85526452__lover
plover115312612_plover
pullover13134642pullover
rollover1144452rollover
sallower11139502sallower
walkover1842942walkover
walloper13147112walloper
wallower14158932wallower
abler75624313abl__er
above105414323a_bove_
aboves114512843a_boves
absolver1343683absolver
adorer74713443a_dorer
aiver85725163a__iver
alder65421913a_l_der
aldose7311093aldose_
aldoses8311203aldoses
alerter72111513alerter
algor6513053algo__r
aliener71011193aliener
aligner8108303aligner
aliner65621983a_liner
alive85722513a_live_
allayed11138063allayed
allayers11156633allayers
allee54932123all__ee
allees64521483all_ees
allege74314643allege_
alleged9389313alleged
allegers9378233allegers
alleges84212563alleges
allele64514563allele_
alleles73812033alleles
alley85721673all__ey
allied74217153all_ied
allies63827673all_ies
allobars1046583allobars
allod64418373allo__d
allodia8128793allodia
allods73615083allo_ds
allometry1445183allometry
allonge837023allonge
allonges937313allonges
allonym1244733allonym
allosaur8133813allosaur
allostery1243723allostery
allot54933873allo__t
allots64019173allo_ts
allotted986873allotted
allottee887123allottee
allotters965563allotters
allow85420663allo__w
allows94517683allo_ws
alloxan1445773alloxan
alloy85519973allo__y
alloys94014563allo_ys
allseed835953allseed
allude73910903allude_
alluded9327093alluded
alludes83610333alludes
allure63012943allure_
allured8299173allured
allurers8286773allurers
allures72913113allures
alluvia1045193alluvia
almner85710723a_lmner
almoners1068133almoners
aloe45540193a_lo_e_
aloes54933673a_lo_es
alone55732963a_lone_
alter54828503a_l_ter
alterer72713993alterer
annoyer1095603annoyer
apposer1147483apposer
approver15105303approver
aquiver1934753aquiver
armorer9259903armorer
arriver10117793arriver
aslope839013aslope_
atoner64817193a_toner
aulder7511453aul_der
aver75931883a___ver
avower1236823a_vower
baller83825203ball__er
ballonet10314503ballonet
balloted1189043balloted
balloters1157673balloters
ballsier1036523ballsier
bellower13159063bellower
beloved13188393beloved
bloomer11419813bloomer
blooper11358533blooper
blower115316573_blower
boilover1344023boilover
caller85125483call__er
calliper1247513calliper
callose9313653callose_
calloses10313383calloses
caloyer1238143caloyer
claver113816973_claver
cleaver124110803cleaver
clever114611533_clever
cloner84418093_cloner
closer84918203_closer
clove105619443_clove_
cloven114211513_cloven
clovers125114663_clovers
clovery15407403_clovery
cloves114918823_cloves
colorer9312523colorer
cover105430773__cover
culver113010633cul_ver
cutover1235283cutover
dallier84215373dall_ier
deliver113312243deliver
delver104913493del_ver
drover104614593_drover
eloper85414153_eloper
elver85216243_el_ver
evolver13275803evolver
falconer1346033falconer
faller94621233fall__er
fallowed15127753fallowed
flivver1633043flivver
flooder11258463flooder
floorer10248073floorer
flopover1642863flopover
flower124815503_flower
flyovers1733673flyovers
follower14137073follower
galloped12107143galloped
gallopers12136323gallopers
glove94516293_glove_
gloved114811873_gloved
glovers114310883_glovers
gloves104115183_gloves
glower105114933_glower
groover11358543groover
halloaed121510153halloaed
halloed113314913hallo_ed
halloes104021513hallo_es
hallooed12168773hallooed
hallowed15179493hallowed
hallowers15137723hallowers
handover15126823handover
hangover15134423hangover
holdover1544083holdover
hollower14127393hollower
hoover124314433_hoover
hover115524133__hover
iller54821293ill__er
laborer9249503laborer
laver85031793__laver
layovers1434073layovers
leaver94321513_leaver
lever85125163__lever
liever94611863_liever
liver85132963__liver
loller63315283_loller
loner55431033__loner
looker104816953_looker
looper83817113_looper
looser65219943_looser
looter64222323_looter
loper75129233__loper
loser54728673__loser
louver94110393_louver
love75234763__love_
loved95021363__loved
lovers94223433__lovers
loves85332013__loves
lower85830413__lower
makeover17113353makeover
mellower13167403mellower
mover104220863__mover
over77227343___over
palaver1238753palaver
pallier94417163pall_ier
pallor8313673pallo__r
passover13135533passover
plovers123611833_plovers
plower114315063_plower
popover1495843popover
prover113819723_prover
pullovers14124243pullovers
rallier73816273rall_ier
recover124312623recover
remover124612273remover
rollovers1244093rollovers
rover85527373__rover
runover1034663runover
sallier73320423sall_ier
sallowed12149033sallowed
salver94617753sal_ver
scalloper1344453scalloper
shallower1555673shallower
shover124515983_shover
silver93815813sil_ver
slalomer1045033slalomer
slaver94419613_slaver
slipover1343833slipover
sliver94116593_sliver
sloper84615913_sloper
sloven9389633_sloven
slower94016153_slower
solver94016703sol_ver
spillover1442613spillover
stover94115643_stover
swallower1554333swallower
takeover15113693takeover
taller63721963tall__er
tallier72817213tall_ier
tallowed12157713tallowed
trover95014663_trover
uncover1239003uncover
unloved112310533unloved
walkovers1942613walkovers
walloped14146833walloped
wallopers14136273wallopers
wallowed15148163wallowed
wallowers15127653wallowers
willower14127453willower
wolver12419713wol_ver
yellower14186213yellower

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272457.92316916.2
3Display Results2452450.0932634.4
 (SQL Overall)1786912458.16921874.3
 
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.