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

444 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
anlace8251392(None) 
anlaces92313731anlaces
anlage72514221anlage
enlace82213231enlace
inlace82513041inlace
unlace82215171unlace
ablate82219212ablate
ablaze17239832ablaze
aflame1138722aflame
aglare7312422aglare
alack114820062a_lack
alae45643752a_la_e
alane56135612a_lane
alate55340322a_late
anglice1089212anglice
anlagen8238632anlagen
anlages82414102anlages
anlas55626932anla_s
anlases72514902anlases
ansae55720972ansa_e
ansate64517862ansate
antae56828292anta_e
anyplace1543852anyplace
apace94718382a_pace
enface112510352enface
enlaced102410522enlaced
enlaces92313392enlaces
glace87420152_glace
inlaced10239872inlaced
inlaces92512902inlaces
lace66848472__lace
palace104516912palace
place94824612_place
relace83122152relace
solace83415822solace
unlaced102913732unlaced
unlaces92513622unlaces
unlade72714152unlade
abaca95118043a_baca
abaci94718843a_baci
aback134816173a_back
abase76023483a_base
abate76627843a_bate
abbacy1536623abbacy
abduce1197193abduce
ablated102513443ablated
ablates92416903ablates
ablaut8313263ablaut
able66340533abl__e
abrade9313053abrade
ace59656833___ace
acuate8315633acuate
acylate12310533acylate
adage7414053a_dage
adduce1076453adduce
adnate72913483adnate
adulate8313233adulate
advance1346043advance
advice12107883advice
aerate64830553aerate
agape85614843a_gape
agate66525143a_gate
agave95314033a_gave
agaze156113663a_gaze
aglee65728493agl_ee
agnate73314873agnate
agrafe1038093agrafe
ala312463603a_la__
alamo7418143a_lamo
alan46844083a_la_n
aland65526413a_land
alang66023513a_lang
alans55636173a_lans
alant55742293a_lant
alar46340073a_la_r
alarm76621423a_larm
alary86123443a_lary
alas46358123a_la_s
alated75625143a_lated
alates64833963a_lates
alcade91111513alcade
ale36572343a_l__e
alec66430063a_lec_
alecs76620733a_lecs
alee46652323a_l_ee
algae65319623a_lgae
alike95523963a_like
aline57243153a_line
alive85722513a_live
alkane104313323alkane
alkie95520033a_lkie
allay85620393alla_y
allayed11138063allayed
allayer10148213allayer
allays94313743allays
allee54932123a_llee
allege74314643allege
allele64514563allele
alliance1097253alliance
allude73910903allude
allure63012943allure
alme65832163a_l_me
almuce10348213almuce
alnico877943alnico
aloe45540193a_l_oe
alone55732963a_lone
alpaca1047383alpaca
alulae6312743alula_e
amaze166016603a_maze
ambage11510593ambage
ambsace1355963ambsace
amerce10310513amerce
amesace1147733amesace
amice96122863a_mice
amylase1237013amylase
ana39559823an_a__
anadem939183an_adem
anal48037523an_a_l
analcime1245393analcime
analcite1049333analcite
anally9513503anally
analog7159963analog
analyse10208893analyse
analyte10158813analyte
analyze19167013analyze
ananke1038283ananke
anarch11310393anarch
anas46649863an_a_s
anatase738943anatase
ancone83916953ancone
andante8311273andante
ane37866943an___e
anear55420323anea_r
aneared8512743aneared
anears63717183anears
anele55628833an_ele
anga56831353anga__
angary10311323angary
angas65827983anga_s
angle64528873an_gle
angulate9312013angulate
anile54634463an_ile
aniline7418473aniline
animacy1446103animacy
animate91617213animate
anime75423203an_ime
anise55129703an_ise
ankle95220253an_kle
anna45529013anna__
annal56520763anna_l
annals66415923annals
annas55824883anna_s
annates72415423annates
annexe1337813annexe
annulate8310923annulate
anoa45634473anoa__
anoas57226493anoa_s
anode65021033an_ode
anole55330373an_ole
anolyte10158993anolyte
anomie83215963anomie
ansa45927773ansa__
ansated84214003ansated
anta46839583anta__
antacid10311203antacid
antas55432033anta_s
ante46538903an__te
antiacne1048583antiacne
antic75728863antic_
antick124814583antick
antics84621453antics
antlike11312073antlike
antre55224523an_tre
anyone94612733anyone
apache134210773a_pache
apiece10510083apiece
aplite8316393aplite
aquae142212713aqua_e
arame75026623a_rame
arcade91013643arcade
arcane81216743arcane
areae55229743area_e
arrack121110253arrack
askance1345923askance
aslant6317753aslant
aslope839013aslope
atlas55821583atla_s
atlases72410643atlases
atlatl637873atlatl
attach11118393attach
attache12106693attache
attack12148153attack
aubade939223aubade
aulic74420243aulic_
aurae54128113aura_e
aurate64426473aurate
aviate9315203aviate
awake125014783a_wake
aware86420023a_ware
axle116424603axl__e
axlike17388853axlike
balance11510263balance
ballade104012563ballade
bandage11311023bandage
belaced124112153belaced
biface1358103biface
black134719073_black
blade85923333_blade
blae66134643_bla_e
blame95625493_blame
blare75826233_blare
blase75524233_blase
blate75933783_blate
blaze165520833_blaze
brace95629273_brace
bullace113410673bullace
canape10913513can_ape
canulae9311183canula_e
canulate10314553canulate
catface1436763catface
cilice103213353cilice
clach124617823_clach
clack134720173_clack
clade85821013_clade
clave105420153_clave
dace76934923__dace
dance85223133dan__ce
deface123113863deface
delate73827753delate
dilate73220693dilate
dolce85816683dol_ce
efface14366673efface
elate55335883_elate
emplace1338263emplace
enact73525363en_act
enate54428143en_ate
encage93713503encage
encase83714363encase
enclave1257533enclave
enfaced13218913enfaced
enfaces122110913enfaces
enflame1236573enflame
engage82812103engage
enhance1239693enhance
enlarge835533enlarge
enolase7310193enolase
enplane939723enplane
enrage72715073enrage
enslave1036273enslave
entice81316863entice
face96140123__face
fallacy1536433fallacy
fanfare1336673fanfare
fanlike142610503fanlike
flack144519413_flack
flake125119973_flake
flame105124443_flame
flare84823633_flare
folate93320393folate
gallate83417123gallate
ganache1346203gan_ache
gelate73421253gelate
glaces94218023_glaces
glade75121963_glade
glance94312313_glance
glare65222953_glare
glaze155418163_glaze
grace85124543_grace
hance105424153han__ce
haulage1136913haulage
haylage1436443haylage
inane52820343in_ane
incage93513623incage
incase83615283incase
induce93811533induce
infare9313083infare
inflame1256963inflame
inflate10312313inflate
ingate73018233ingate
inhale9411513inhale
inlaid7310133inlaid
inland7310313inland
inlay85214323inla_y
inlayer1036933inlayer
inlays9389873inlays
inmate82917353inmate
innage73011573innage
innate63917313innate
insane6314883insane
intact8314663intact
intake10510863intake
inulase739413inulase
invade10157853invade
knack104311043kn_ack
knave12389463kn_ave
knawe12397883kn_awe
lac510155823__lac_
laced87132643__laced
lacer75833753__lacer
laces76141763__laces
lacey105820913__lacey
lack105837683__lack
lacs66942483__lacs
lacy95829633__lacy
lade56345983__lade
lake85741603__lake
lame66849293__lame
lanate6421263lan_ate
lance75126723__lance
lane45153323__lane
lase46148513__lase
late47560483__late
lave75642143__lave
laze136235053__laze
lice66045063__lice
lilac7311073lilac_
lilacs837483lilacs
luce65132573__luce
mace87345783__mace
malate84624553malate
malice104818483malice
manacle11310283man_acle
manage93818903man_age
mandate10315573mandate
maniac103917973maniac_
maniacs114313063maniacs
manlike133012783manlike
manmade1237963manmade
manpack1746063manpack
menace103216943menace
milage93414123milage
nabe66029493_n_abe
nacre75715363_n_acre
nae35952743_n_a_e
nala46930393nala__
nalas55528363nala_s
name65637413_n_ame
nance74721843_nance
nape65230803_n_ape
nave75732313_n_ave
nice65534713_n_ice
niece74814503_niece
nonce75719823_nonce
noplace1137393noplace
nuance859043_nuance
oblate82214743oblate
once65423083on__ce
onlay84212943onla_y
onlays9398713onlays
online6315843online
pace86345773__pace
palaced124110773palaced
palaces114216453palaces
palate84226783palate
panacea1137783pan_acea
panache1458423pan_ache
pancake1536673pancake
parlance1248713parlance
peace95026083_peace
pelage9515363pelage
pinnace113510313pinnace
placed114318003_placed
placer105117743_placer
places104323703_places
placet103923673_placet
plack135017843_plack
plage84520403_plage
plaice10311553_plaice
plane74929143_plane
plate74635113_plate
police102918563police
pomace123111913pomace
race66746263__race
rance75028513ran__ce
ransack1346463ransack
reface113616353reface
relaced103517213relaced
relaces93420883relaces
relate64033633relate
replace113214283replace
rubace10310173rubace
silage72715303silage
silane62718053silane
slack115021763_slack
slake93724053_slake
slate55438283_slate
slave84224033_slave
slice74925823_slice
snack114718063sn_ack
snake94821113sn_ake
snare54429983sn_are
solaced102911063solaced
solacer93011103solacer
solaces93116133solaces
solate64526073solate
space95325673_space
splake1259783splake
splice104915103splice
tace65342513__tace
tailrace1044883tailrace
tallage82712073tallage
tankage12257773tankage
tannage8209583tannage
tannate71813523tannate
telae54323293tela_e
tenace82715693tenace
tolane64316583tolane
trace75829613_trace
ullage739043ullage
ulnae55214573ulna_e
unbale83616403unbale
unbrace111910483unbrace
uncage93014873uncage
uncake122813523uncake
uncase83817433uncase
unease63816643unease
uniface1236953uniface
unladed92614373unladed
unladen8248653unladen
unlades82612833unlades
unlaid7311753unlaid
unlash938793unlash
unlatch1245053unlatch
unlay84613703unla_y
unlays93810493unlays
unlike102614063unlike
unlive92712333unlive
unlock1248533unlock
unmade92911063unmade
unmake122811213unmake
unpack1457833unpack
unplaced1338613unplaced
unsafe9310693unsafe
untack1239763untack
untame82513603untame
valance1269253valance
vallate103016563vallate
vantage11109893vantage
velate93720143velate
veloce11310133veloce
vendace1357363vendace
vivace1436553vivace
wannabe1234533wannabe
wantage11119623wantage

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164445.70319764.3
3Display Results4444440.1233609.8
 (SQL Overall)1786914445.96629951.6
 
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.