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

122 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
ghettos113447(None) 
ghetto1036071ghetto_
ghettoes1243491ghettoes
ghettoed1342082ghettoed
grottos8337332grottos
abettor956193abettor
abettors1056133abettors
anattos7138453anattos
bentos86218303_bentos
bettas84913923_bettas
bettor83612223_bettor
bettors93312473_bettors
cavettos1344973cavettos
centos85920463_centos
cestos84718093_cestos
cheapos14418513cheapos
cheats114519543cheat_s
cheeros123711633cheeros
chemos13311723che_mos
cherts115617233chert_s
chests114916263chest_s
chetahs15347073chetahs
cheths14389823che_ths
chotts113610993chott_s
dattos74311903_dattos
dittos74111973_dittos
ethos85514193__ethos
galettes93111163galettes
gazettes18296863gazettes
geckos13457433g_eckos
geests75912163geest_s
gelatos83111523gelatos
gelts65924613g_elt_s
gemots93712153g_emots
genettes938303genettes
genros74211333g_enros
gentes75324163g_entes
gentoo7311313g_entoo
gentoos838633gentoos
gents65729613g_ent_s
gestes75721393g_estes
gests66028813g_est_s
getas65421483g_e_tas
gets55442483g_e_t_s
getter74117613g_etter
getters84216103g_etters
getups9346853g_etups
ghats95818613gh_at_s
ghauts10447783ghaut_s
ghees95215553ghe__es
gherao1036753gherao_
gheraoes1244813gheraoes
ghettoing1442123ghettoing
ghettoize2251563ghettoize
ghettoizes2351563ghettoizes
ghosts10489273ghost_s
gjetost1543223gje_tost
gleets75315053gleet_s
glottis837173glottis
glutton844893glutton
gluttons944273gluttons
greats76318393great_s
greets75117423greet_s
gregos847533gre_gos
grotto7349813grotto_
grottoes9276753grottoes
guests74311203guest_s
heaths126316383_heaths
heats85838403_heat_s
hector113312653_hector
hectors123513263_hectors
hefts116218153_heft_s
helios94816633_helios
hellos95321683_hellos
helos84928063_he_los
helots95217703_helots
hents87330743_hent_s
heptose1237493_heptose
heros84930863_he_ros
hests85829933_hest_s
heteros10312683_heteros
heths116317783_he_ths
hets75547203_he_t_s
jetton1338033_jetton
jettons1437273_jettons
kheths16495973khe_ths
khets124913433khe_t_s
kleptos1344363kleptos
larghettos1452213larghettos
lentos65317403_lentos
lottos64613103_lottos
metros84217803_metros
mottos84615243_mottos
netts55320723_nett_s
obentos936703obentos
ottos54714323__ottos
pestos84719083_pestos
petto76021043_petto_
photos113316643ph_otos
pottos84615873_pottos
prestos93716083prestos
rectos85718783_rectos
retros63820193_retros
rhetor938063rhe_tor
rhetors1038513rhetors
setts55124323_sett_s
sextos134012163_sextos
sheaths1358753sheaths
sheets93918503sheet_s
sheltas10279673sheltas
shotts93614703shott_s
shtetls1034583shtetls
strettos847113strettos
thefts12387923theft_s
thermos124610753thermos
thetas93011573the_tas
wheats125013223wheat_s
whets115019613whe_t_s
whetted14256693whetted
whetter13348803whetter
whetters14246653whetters
yetts86715133_yett_s

Search took 8 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.406440125.6
2DLD Change Limit1340271226.84319586.0
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.29524495.0
 
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.