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

280 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
custom10401027(None) 
customs11348261customs
custos84014311custos
accustom1443662accustom
castor84418532castor
cestoi84511952cestoi
cestos84718092cestos
cusso74912292cusso_
cussos84210002cussos
custody1334092custody
customer1245382customer
gusto65414642gusto_
accustoms1543343accustoms
atom67824523__atom
ausform1245243ausform
auto47432083au_to_
autos56523323au_tos
besom95716973bes_om
bestow1149463bestow
bosom95516923bos_om
boston8513043boston
bottom1048723bottom
burton8311273burton
busboy13307443busboy
bust65947783bust__
busted95123153busted
buster84726493buster
bustic101012693bustic
bustle84015483bustle
busts75227693bust_s
busty105621013bust_y
button8310273button
buxom1647153bu_xom
canto74931013canto_
canton85722993canton
cantor85621523cantor
cantos84826973cantos
captor104914603captor
carom95025563c_arom
carrom10513403carrom
carton84522663carton
cartop104213563cartop
cashoo11312253cashoo
cast67159903cast__
caste75932363cast_e
caster85232573caster
castes85631863castes
castle84918963castle
castoff1547793castoff
castors94919443castors
casts77237793cast_s
caustic1139753caustic
celom9515693c_elom
cento76625173cento_
centos85920463centos
centum104012363centum
cesium1039583cesium
cesta75419483cest_a
cestas85018543cestas
cesti75217423cest_i
cestode1037963cestode
cestoid104011673cestoid
cestus84412913cestus
chiton112612393chiton
cisco95112133cisco_
ciscos104711133ciscos
cist67244973cist__
cisted95217523cisted
cistron9299883cistron
cists76624533cist_s
cistus84611343cistus
cluster94013333cluster
coelom10310433coelom
condom114215363condom
conto76027173conto_
contos84923233contos
cosmos10311753cosmos
cost68057943cost__
costa75523733cost_a
costae85319683costae
costal85419513costal
costar85518613costar
costed95623123costed
coster84331293coster
costly114012333costly
costs77231143cost_s
costume1157853costume
cotton8312993cotton
craton84517193craton
croton84415453croton
crust75827663crust__
crustal939023crustal
crusted103712763crusted
crustose1045503crustose
crusts84916543crust_s
crusty114911343crust_y
cuatro838433cuatro
cuatros938273cuatros
cubism12348703cubism
cuckoo1486413cuckoo
cuesta838513cuest_a
cuestas957933cuestas
culm85822383cu__lm
cult66541153cult__
cultch13385953cultch
culti76317253cult_i
cultic105111903cultic
cultism11158003cultism
cults75022553cult_s
cultus85110733cultus
cum76440163cu___m
cundum1136513cundum
cunt66243673cunt__
cunts76125123cunt_s
cuprum1236743cuprum
curator9312213curator
curio74221213curio_
curios83218333curios
curium10312503curium
cursor84110293cursor
curst74931023curst__
curt67051713curt__
curtal83914543curtal
curter85320083curter
curtly1149283curtly
curtsy1156643curtsy
cuscus1038113cuscus
cusec94614903cus_ec
cusecs10509153cusecs
cushat113513693cushat
cushaw14386983cushaw
cushion1236403cushion
cushy134412323cus_hy
cusk105521633cus__k
cusks114916053cus_ks
cusp86021063cus__p
cuspal1037883cuspal
cusped114312043cusped
cuspid11429213cuspid
cuspis105010703cuspis
cusps94913673cus_ps
cuss65430613cus__s
cussed94917123cussed
cusser86016093cusser
cusses84522773cusses
custard10389973custard
custodes1136653custodes
customary1643513customary
customers1344783customers
customise1344863customise
customize2244073customize
custumal12113593custumal
cut57957663cu_t__
cutch125116193cu_tch
cute66440453cu_t_e
cuter74728233cu_ter
cutes79438323cu_tes
cutey105819793cu_tey
cutie76925933cu_tie
cutin75022783cu_tin
cutis77723763cu_tis
cutoff1436563cu_toff
cutout8315923cu_tout
cuts65841153cu_t_s
cutter84521003cutter
cuttle84113893cuttle
cutty105417223cu_tty
cutup9410093cu_tup
cutworm14186353cutworm
cyst96322813cyst__
cystic132710653cystic
cystoid13309213cystoid
cysts105912773cyst_s
cyton101511463c_yton
diatom939453diatom
distome10313233distome
dust57142533dust__
dusted83918373dusted
duster74919723duster
dustoff1445053dustoff
dusts65923563dust_s
dustup935363dustup
dusty96018333dust_y
estop74312103_estop
fantom112110803fantom
frustum1243953frustum
fusion939773fusion
fustic11910633fustic
fusty115016523fust_y
futon83113773fu_ton
gust55240703gust__
gusted84316723gusted
gustoes879873gustoes
gusts65722793gust_s
gusty95119573gust_y
hustle93113993hustle
jetsom15126143jetsom
junto125114563junto_
juntos134110843juntos
just115433343just__
justed144215773justed
juster134617013juster
justle133211583justle
justly16307253justly
justs124918263just_s
kusso9398033kusso_
kussos10336423kussos
lissom837403lissom
lust47442603lust__
lusted74319443lusted
luster64023673luster
lustra6358893lustra
lustre64011683lustre
lustrum945853lustrum
lusts55022803lust_s
lusty85417573lust_y
madtom1138023madtom
museum1037703museum
muskox1933953muskox
must65145443must__
musted93321073musted
mustee83922103mustee
muster84724523muster
musth105314783must_h
musths11589483musths
musts75527443must_s
musty105620953must_y
muton73817003mu_ton
mutton8510453mutton
nestor63713423nestor
neuston736083neuston
nostoc868193nostoc
ostomy1137833_ostomy
oust46747443oust__
ousted73720583ousted
ouster64223733ouster
ousts55225703oust_s
pastor84817483pastor
pesto75723723pesto_
pestos84719083pestos
pistol83313333pistol
piston83515923piston
pistou83211843pistou
postop10511943postop
punto75121323punto_
puntos85915793puntos
puton73617913pu_ton
putto75617663putto_
questor16146633questor
rust45544913rust__
rusted75020923rusted
rustic8712673rustic
rustle63615413rustle
rusts55026993rust_s
rusty85221053rust_y
scutum1036373scu_tum
som59153813__s_om
stem610628253__stem
stoa45425913__stoa
stob66724613__stob
stoma75918273__stoma
stomp95616663__stomp
stop66532033__stop
storm76520403__storm
stot46347333__stot
stow77325743__stow
stum65526023__stum
subatom1147053subatom
suitor63311053suitor
system1135743system
teston6313303teston
tom514358053___tom
trustor7238413trustor
tussor6378233tussor
tutor5712493tu_tor
unstop837473unstop
unto45824283_unto_
wisdom1235983wisdom
xystoi16365133xystoi
xystos16356913xystos

Search took 9 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.750238254.7
2DLD Change Limit1127162807.72014600.5
3Display Results2802800.0933010.8
 (SQL Overall)1786912808.56320867.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.