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

168 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
diobol93688(None) 
diobols1036541diobols
cibol9512022ci_bol
diabolo1065482diabolo
diobolon1143192diobolon
diol57329132di__ol
drool65416102dro_ol
obol65220612__obol
adobo84711593adobo_
adobos9438453adobos
babool103012153babool
bilbo95513613bilbo_
bilboa10367843bilboa
bilbos105011203bilbos
bimbo114811873bimbo_
bimbos124610523bimbos
booboo1039463booboo
cibols1039523ci_bols
cineol8108203cineol
cool66940493_co_ol
dewool1047403dewool
dhobi1136973dhob_i
dhobis1236113dhobis
dhooly13457143dho_oly
diabolic1345733diabolic
diabolos1174643diabolos
dial55935063di__al
dialog837973dialog
diatom939453diatom
diazo15310033diazo_
diazole1736793diazole
dib65746943di_b__
dibbed124713473dibbed
dibber114614713dibber
dibble114013843dibble
dibbuk1543503dibbuk
dibs76233683di_b_s
dicot85429093di_cot
dicotyl1344403dicotyl
dido66528193di_do_
didos76820813di_dos
diel59034603di__el
diesel74410403diesel
diglot83014333diglot
dildo71911773dildo_
dildoe8198673dildoe
dildos8179303dildos
dill55239973di__ll
dingo74720793dingo_
dino56036753di_no_
dinos65428063di_nos
diobolons1243123diobolons
diode74716113dio_de
diodes83915783diodes
dioecy1235543dioecy
diols65521013dio_ls
dioxan1465773dioxan
dioxid1568393dioxid
dioxin14118783dioxin
diploe9810153diploe
dipole91112853di_pole
dipso85111553dipso_
dipsos95310053dipsos
dirl57430023di__rl
dirndl834253dirndl
disbar938513disbar
disbowel14115213disbowel
disbud10165713disbud
disco85616073disco_
discos94915213discos
dismal92412243dismal
disobey1346243disobey
dispel9310323dispel
distal73615773distal
distil73616433distil
dithiol1145433dithiol
ditto65315603ditto_
dittos74111973dittos
diuron738573diuron
divot95723073di_vot
djebel1643453djebel
dobby136013633d_obby
dobie84920333d_obie
dobla84913643d_obla
doblon938013d_oblon
dobra85013103d_obra
dobro84412213d_obro
dobros93910233d_obros
dobson936593d_obson
doby106022163d_ob_y
dodo66024913d_odo_
dodos75819393d_odos
dojo126016143d_ojo_
dojos135111793d_ojos
dol47150653d___ol
doll56632493d_o_ll
dolor67617963d_olor
domal85619203d_omal
donor64418193d_onor
doobie94712683doobie
doodoo8108893doodoo
dooly94821803d_o_oly
doom76430073d_o_om
door56928513d_o_or
doowop1283853doowop
dotal64919623d_otal
dowel95618193d_owel
droll65415403dro_ll
dromon939363dromon
drools74412813dro_ols
drooly104911073dro_oly
droop85814823dro_op
dumbo105614063dumbo_
dumbos114111083dumbos
duolog835803duolog
duomo839753duomo_
duomos936823duomos
duopoly1343683duopoly
fool75330593_fo_ol
gambol1138223gambol
gibbon1135323gibbon
gimbal11228813gimbal
girosol885303girosol
global937663global
gobo76126903_gobo_
gobos86219383_gobos
googol835843googol
hobo97026083_hobo_
hobos106321353_hobos
idol56818633_i_dol
indol63714873_indol
kobo107422103_kobo_
kobold1365963_kobold
kobos115616893_kobos
libel74116103li_bel
limbo95614813limbo_
limbos104712143limbos
lintol6369473lintol
lobo67229863_lobo_
lobos75921843_lobos
mool67533863_mo_ol
nicol71113293ni_col
niobic1037243niobic
niobous936333niobous
oboe66822943__oboe
obole75917143__obole
oboli73712873__oboli
obols73715863__obols
pibal95217323pi_bal
pistol83313333pistol
poboy121612223_poboy
pool65835953_po_ol
ribbon1036533ribbon
robot7325973_robot
shool84523153sho_ol
sibyl1037113si_byl
snool55118643sno_ol
sokol94612293_sokol
sotol54917653_sotol
spool75219043spo_ol
stool55619893sto_ol
symbol1336083symbol
timbal102510753timbal
timolol944113timolol
tool46735683_to_ol
viol76523593vi__ol
wittol935923wittol
wool76427373_wo_ol

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.1261418182.5
2DLD Change Limit1127161685.48320557.4
3Display Results1681680.0503360.0
 (SQL Overall)1786911685.65931576.4
 
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.