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

145 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
dagoba107494(None) 
dagobas1145141dagobas
agora6914332_agora
dagga839542dag_ga
dago65725082dago__
dagoes85714602dagoes
dagos76419442dago_s
pagoda10487872pagoda
aba512850953_a__ba
abba810522643_a_bba
aboma91114603_aboma
adobe84814703_adobe
adobo84711593_adobo
aga410447233_ag__a
agama85815573_agama
agha87417303_ag_ha
agita6315423_agita
agma77623263_ag_ma
ago48845523_ago__
agog68019003_ago_g
agon56531883_ago_n
agonal7410053_agonal
agone65924553_agone
agons66423783_agons
agony96415653_agony
agorae7511203_agorae
agoras7613343_agoras
agria65517143_agria
alba68328333_a_lba
aloha8513613_aloha
ameba9312373_ameba
amoeba1035593_amoeba
angora71111573angora
anoa45634473_ano_a
araroba945763araroba
aroma71220143_aroma
arroba898663arroba
baba88828343ba__ba
balboa10389963balboa
baobab946403ba_obab
cabob114616803cabob_
cabobs124311883cabobs
cabomba1544083cabomba
caeoma1039033caeoma
canola8313623canola
carob95325223carob_
carobs104818103carobs
casaba1079263casaba
dab67455563da__b_
dabs77139403da__bs
dacha114812573da_cha
dacoit9415443dacoit
dada66422443da__da
dado67126333dado__
dadoed9449893dadoed
dadoes85616533dadoes
dados75522433dado_s
dag57753003dag___
daggas937973daggas
dagger95017293dagger
daggle93711903daggle
daglock1544263daglock
dags66642593dag__s
dagwood1344833dagwood
dahlia1035773dahlia
dahoon1039053dahoon
dakoit11310333dakoit
darb76033533da_rb_
darbar959953da_rbar
darbs85323263da_rbs
data56026653da__ta
datcha1266563datcha
dato56129943dato__
datos65222783dato_s
datura738023datura
daub77423443da_ub_
daube85015303da_ube
daubs85014563da_ubs
dauby115211223da_uby
demob104913503demob_
demobs11429483demobs
dhobi1136963d_hobi
dhoora1035653dhoora
diagonal1095653diagonal
dobla84913643d__obla
dobra85013103d__obra
doby106022163d__oby
dogma96112463dog_ma
dona55529633d__ona
dongola945473dongola
dopa77220903d__opa
dragoman1244653dragoman
dragon838843drago_n
dragons938383dragons
dragoon935283dragoon
dugong934373dugong
dugout8310363dugout
fagot9323403fago_t
fagots1039963fagots
gaga66625553gag__a
gamba106018513ga_mba
goa47343803__go_a
gob68950893__gob_
goban84414073__goban
gobo76126893__gobo
gobs76935573__gobs
goby106021083__goby
jagra1338173jag_ra
jojoba1441553jojoba
kabob134113923kabob_
kabobs14439293kabobs
lagoon7410483lagoon
laguna7127223laguna
magma104513573mag_ma
magot8326393mago_t
magots9312363magots
mamba116317513ma_mba
nabob93913733nabob_
nabobs10388203nabobs
nagana748943nagana
oba57531553___oba
pagod95013683pago_d
pagodas11367553pagodas
pagods105310193pagods
pakora1247283pakora
payola11208113payola
raga55930813rag__a
ragbag1045463rag_bag
ragout7317183ragout
ramona8412413ramona
rugola736293rugola
rugosa734563rugosa
saga55331173sag__a
sago56332673sago__
sagos66123873sago_s
samba95618773sa_mba
samosa8510203samosa
sapota8310203sapota
soba64927923__soba
vagina102710933vagina
wagon94312953wago_n
wagons103911213wagons
zareba1736423zareba
zariba1736973zariba
zygoma2143493zygoma

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 Limit1127161454.83023336.6
3Display Results1451450.0463152.2
 (SQL Overall)1786911455.01635624.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.