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 “curt” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

266 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
curt6705171(None) 
cart66570341cart
court75532771court
cult66541151cult
cunt66243671cunt
cur56841981cur_
curb86732221curb
curd77634981curd
cure66149121cure
curet75447641curet
curf97538781curf
curl66035051curl
curn66731891curn
curr65429651curr
curs65645541curs
curst74931021curst
cut57957661cu_t
hurt77142571hurt
yurt76435041yurt
airt45757782airt
art38679142_art
aunt46553652aunt
aura45836252aura
blurt77625622blurt
bort65960962bort
brut66537962brut
bunt65850852bunt
bur55744692bur_
bura66139532bura
burb85334672burb
burd75534262burd
buret77444012buret
burg74930362burg
burl64937182burl
burn65636432burn
burnt75230332burnt
burp85028882burp
burr65631232burr
burs65847422burs
burst75332242burst
bury95633592bury
bust65947782bust
but55963022bu_t
butt65143742butt
cant66362032cant
car59165562car_
carat75048792carat
carb85143162carb
card710245872card
care66968372care
caret75360562caret
cark105539272cark
carl65144782carl
carn66245432carn
carp85139812carp
carr65434702carr
cars67364762cars
carte75940422carte
carts78946292carts
cast67159902cast
cat58282342c_at
celt65646712celt
cent67451012cent
cere66741472cere
cero66329452cero
chart105038282chart
chat95546132chat
chert105232102chert
chit96937462chit
churl105913882churl
churn105113102churn
churr104512852churr
cire65836372cire
cist67244962cist
clot66542422clot
coat67558352coat
coft97939682coft
colt67158242colt
coot67860382coot
cor59960942cor_
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corm85735382corm
corn69945812corn
cors66656442cors
cory96941512cory
cost68057942cost
cot510483222c_ot
count74932052count
courts84216172courts
crit65743712crit
cru57129562c_ru
crud75219612crud
cruet74831842cruet
crura7312582crura
crus65828482crus
crust75827662crust
crux135415002crux
cry89726242c_ry
cub76940942cu_b
cube85830212cube
cubit94122892cubit
cubs85832382cubs
cud67937452cu_d
cuds76730472cuds
cue57544182cu_e
cued76329562cued
cues65438982cues
cuff125327992cuff
cuif96529142cuif
cuke105824982cuke
culet76040342culet
cull65929642cull
culm85822382culm
culti76317252culti
cults75022552cults
cum76440162cu_m
cunts76125122cunts
cup76738242cu_p
cups85430822cups
curate85226242curate
curbs94821652curbs
curch124415412curch
curds85725612curds
curdy115916522curdy
cured85932132cured
curer75030752curer
cures75645432cures
curets84922342curets
curfs105122142curfs
curia74523772curia
curie74533042curie
curio74221212curio
curite85222942curite
curls74927102curls
curly105321232curly
curns74924282curns
currs75624392currs
curry105920342curry
curse75829142curse
curtal83914542curtal
curter85320082curter
curtly1149282curtly
curtsy1156642curtsy
curve104920022curve
curvet114720242curvet
curvy136013372curvy
cusk105521632cusk
cusp86021062cusp
cuss65430612cuss
cute66440452cute
cuts65841152cuts
cutty105417222cutty
cyst96322812cyst
dart55857872dart
dirt55550382dirt
duct75735462duct
duet56446262duet
duit56241582duit
dunt55746872dunt
dura55232112dura
dure56341812dure
durn56127632durn
duro56228022duro
durr55624352durr
durst66125172durst
dust57142532dust
euro45325272euro
fart76860562fart
fort76456442fort
fur66637322fur_
furl77030882furl
furs76735042furs
fury107727972fury
girt56646422girt
guru54623912guru
gust55240702gust
gut46753852gu_t
hart76865772hart
hunt76445492hunt
hurl76029932hurl
hurst85527192hurst
hurts86922822hurts
hut66457292hu_t
jura116024892jura
jurat124829322jurat
jury146719592jury
just115433342just
jut105944012ju_t
kart86750802kart
kurta95113912kurta
kuru85521802kuru
lunt46148842lunt
lure45142462lure
lurk86624162lurk
lust47442602lust
mart66865982mart
mort66758832mort
mura65633302mura
mure65941332mure
murk105527252murk
murr65225132murr
must65145442must
mut58357182mu_t
mutt65739402mutt
nurd56224342nurd
nurl45327242nurl
nut36651962nu_t
ort39465232_ort
our36042892our_
ours47237562ours
oust46747442oust
out38072152ou_t
part65967462part
pert66759322pert
port66059632port
punt65747202punt
pur56840552pur_
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
purty105019402purty
put55759072pu_t
putt66937842putt
quart144027852quart
quirt144624232quirt
quit136136512quit
runt46647992runt
rust45544912rust
rut35560522ru_t
scart76139772scart
scurf104719322scurf
scut65835542scu_t
sort46264812sort
spurt77227982spurt
sturt56028962sturt
suet46754822suet
suit45649872suit
sura45740292sura
surd56433812surd
sure45447412sure
surf76039312surf
tart47566182tart
tort46967462tort
tuft76929512tuft
turd56027622turd
turf75334052turf
turk86125862turk
turn46330392turn
tut36758092tu_t
urb55731112_urb
urd46427052_urd
urn35731472_urn
urp56426402_urp
ut28647032_u_t
vert77249372vert
wart77866082wart
wert79749822wert
wort76654752wort
wurst85122992wurst
yurta86014252yurta
yurts87216532yurts

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298722660.86034734.9
3Display Results2662660.0634222.2
 (SQL Overall)1786912661.189150286.8
 
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.