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

247 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
dialog83797(None) 
dialogs938101dialogs
analog7159962analog
decalog1136002decalog
dial55935062dial__
dialed84716452dialed
dialer74315432dialer
dialing94318172dialing
dialoged1146692dialoged
dialoger1056082dialoger
dialogic1247442dialogic
dialogue1044792dialogue
dials64925342dial_s
diatom939452diatom
diazo15310032diazo_
diglot83014332diglot
diploe9810152diploe
duolog835802duolog
agog68019003__agog
aloe45540193__aloe
along65419493__along
alow75328593__alow
analogs82810443analogs
analogy11177843analogy
apolog938903apolog
bailor83412603bailor
beclog1136863beclog
biali73419073bial_i
bialis83617163bialis
bialy105119323bial_y
bialys11387913bialys
billon83713823billon
billow114111223billow
biog76122313bi__og
biology1337363biology
blog75723823__blog
calo64936443_calo_
calos74431903_calos
catalog1038003catalog
chalot113020133chalot
ciao64924183cia_o_
clog76123243__clog
colog86619933_colog
dado67126333d_ado_
dados75522433d_ados
dag57753003d_a__g
dago65725083d_ago_
dagos76419443d_agos
daikon11217243daikon
daily95922333dail_y
daimon9259713daimon
dal47554953d_al__
dale55643983d_al_e
dales66439743d_ales
dally95324743d_ally
dals57145123d_al_s
dalton7311273d_alton
dang65131533d_a_ng
dato56129943d_ato_
datos65222783d_atos
daylong1233973daylong
deacon9510423deacon
deal56347413deal__
dealer74122143dealer
dealing94323233dealing
deals65435343deal_s
dealt65234283deal_t
decalogs1245623decalogs
defog1048523d_efog
demagog1243853demagog
deploy1237583deploy
dhal86719283dhal__
dhals95415443dhal_s
diabolo1065483diabolo
diabolos1174643diabolos
diacid10310633diacid
diadem1037583diadem
dialect101210263dialect
dialers83614293dialers
dialings10329823dialings
dialist8517763dialist
diallage1045233diallage
dialled9510133dialled
diallel845683diallel
dialler848813dialler
dialling10310783dialling
dialogers1155163dialogers
dialoging1246313dialoging
dialogist1148273dialogist
dialogued1243693dialogued
dialoguer1143163dialoguer
dialogues1144813dialogues
dialyse1135463dialyse
dialyze2044433dialyze
diamin9312513diamin
diamond1186113diamond
diaper94513113diaper
diapir9357113diapir
diary95016973dia_ry
diatoms1039073diatoms
diatron839283diatron
diazin1639163diazin
diazole1736793diazole
dicing105718763dicing
dicot85429093di_cot
dido66528193di_do_
didos76820813di_dos
dieing84018653dieing
diel59034603diel__
dig57544473di___g
diglots9299503diglots
diking124320243diking
dilate73220693dilate
dilator82712783dilator
dildo71911773di_ldo
dildoe8198673dildoe
dildos8179303dildos
dill55239973di_l_l
dilled84122223dilled
dills65530973di_lls
dilly94923783di_lly
dimly114913483diml_y
ding66940953di__ng
dingo74720793dingo_
dining84525133dining
dino56036753di_no_
dinos65428063di_nos
diobol936883diobol
diol57329133di__ol
diols65521013diol_s
diplex16408053diplex
diploes101111483diploes
diploic1247763diploic
diploid11310283diploid
diploma1295933diploma
diplont10311693diplont
dipole91112853dipole
dipso85111553dipso_
dipsos95310053dipsos
dirl57430023dirl__
dirled84514903dirled
dirling93316073dirling
dirls64720503dirl_s
disallow1243513disallow
disavow1443603disavow
disco85616073disco_
discos94915213discos
dislodge1145173dislodge
ditto65315603ditto_
dittos74111973dittos
diuron738573diuron
diving113717953diving
divot95723073di_vot
doblon938013doblon
dog57449753d___og
dogleg936323dogleg
dollop9259363dollop
dolor67617963d_olor
drag64825053dra__g
dragon838843dragon
drylot1037403drylot
dual55928173dual__
dually103210063dually
duals65620083dual_s
duologs935363duologs
epilog976463epilog
etalon648973etalon
fillo84319783fillo_
fillos94415073fillos
filo76034283fi_lo_
filos86125383fi_los
flog85523893__flog
galop84716213_galop
giglot84013133giglot
halo76437323_halo_
halon86124863_halon
halos85230253_halos
hidalgo1242373hidalgo
hillo84721653hillo_
hilloa94713033hilloa
hillos94618883hillos
idealogy1342943idealogy
igloo6410493_igloo
incog838253_incog
isolog737403isolog
jailor13418573jailor
jalop144212603_jalop
jiao115017843jia_o_
kalong1177703_kalong
kiang104811353kia_ng
kilo86028663ki_lo_
kilos95021473ki_los
liang64914413lia_ng
lilo46731563li_lo_
lilos55821873li_los
linalol745093linalol
log46252683___log
magalog1144903magalog
miaou7513083mia_ou
miaow1058353mia_ow
midleg1038553midleg
milo65536093mi_lo_
milos75428013mi_los
pial65636703pial__
piano76118713piano_
pianos84315933pianos
pillow113110573pillow
pilot77435063pi_lot
pirog83913673pi_rog
prolog94212973prolog
putlog965553putlog
quahog1944103quahog
rial45938093rial__
rials55026673rial_s
rialto638603rialto
rialtos736613rialtos
sailor63113743sailor
salol55222143_salol
salon55228553_salon
sawlog1035793sawlog
seadog838743seadog
shalom11810913shalom
sial45938833sial__
sialic8313633sialic
sialid7314933sialid
sialoid8310953sialoid
sials54227243sial_s
sigloi737733sigloi
siglos7311463siglos
silo46037913si_lo_
silos56029423si_los
slalom888173slalom
slog56728273__slog
stalag7310023stalag
tailor63412503tailor
talon55824113_talon
tiglon737913tiglon
unclog956603unclog
valor83614893_valor
vial76731093vial__
vialed105112593vialed
vialing113614163vialing
vials85822383vial_s
viator93211833viator
weblog1234223weblog
willow12369693willow
zealot15313473zealot

Search took 6 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 Limit1127162475.40620850.2
3Display Results2472470.0763250.0
 (SQL Overall)1786912475.62231784.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.