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

137 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
court7553277(None) 
count74932051count
courts84216171courts
curt67051711c_urt
blurt77625622blurt
boart78835932boart
bort65960962bo_rt
bourg84113842bourg
bourn75518482bourn
bout66353292bou_t
cart66570342c_art
chart105038282chart
chert105232102chert
churl105913882churl
churn105113102churn
churr104512852churr
clour76617282clour_
clours85215092clours
clout75330462clou_t
coact96130582coact
coapt96131532coapt
coast75236272coast
coat67558352co_at
cobra95214402cobra
coft97939682co_ft
cohort1110720262cohort
coir66327242coir_
coirs75221052coirs
colt67158242co_lt
colure8314162colure
comet95946072comet
compt116328222compt
coopt95929852coopt
coot67860382co_ot
copra98115462copra
coquet174318012coquet
cor59960942co_r_
cord76740922co_rd
core67263112co_re
corf95941482co_rf
cork106635692co_rk
corm85735372co_rm
corn69945812co_rn
cors66656442co_rs
cory96941512co_ry
coset75748842coset
cost68057942co_st
cot510483222co__t
couch125320112couch
coude85022632coude
cough115819642cough
could86517712could
counts84618272counts
county114313322county
coup86729792cou_p
coupe96023482coupe
coups95522472coups
courant9317972courant
course85117782course
courted103514922courted
courter94516482courter
courtly1256922courtly
couth106122492couth
covert114925502covert
covet105638942covet
cowry135512482cowry
cruet74831842cruet
crura7312582crura
crust75827662crust
cult66541152c_ult
cunt66243672c_unt
cur56841982c_ur_
curb86732222c_urb
curd77634982c_urd
cure66149122c_ure
curet75447642c_uret
curf97538782c_urf
curl66035052c_url
curn66731882c_urn
curr65429652c_urr
curs65645542c_urs
curst74931022c_urst
cut57957662c_u_t
doubt8720092doubt
dour56330432dour_
doura66518662doura
fort76456442fo_rt
fount84727032fount
four76226862four_
fours85521492fours
fourth12357442fourth
gourd71011902gourd
gout56646002gou_t
hour75827312hour_
houri85915252houri
hours85422392hours
hurt77142572_hurt
joust125122292joust
lour45430682lour_
lours55125292lours
loury85716752loury
lout45952142lou_t
mort66758832mo_rt
moult74728722moult
mount74128062mount
mourn77215012mourn
ort39465232_o_rt
our36042892_our_
ours47237562_ours
oust46747442_oust
out38072152_ou_t
port66059632po_rt
poult76928872poult
pour611527472pour_
pours74623182pours
pout65752552pou_t
roust55532062roust
rout46153282rou_t
scour75315532scour_
scours84913592scours
scout75031452scou_t
sort46264812so_rt
sour45935892sour_
sours55230502sours
spurt77227982spurt
sturt56028962sturt
tort46967462to_rt
tour45530382tour_
tours55325892tours
tout46753822tou_t
upcourt1146102upcourt
wort76654752wo_rt
yogurt1037822yogurt
your78623432your_
yourn87512772yourn
yours85217882yours
yurt76435042_yurt

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 Filter178691538000.0931921408.6
2DLD Change Limit538001371.53035163.4
3Display Results1371370.0334151.5
 (SQL Overall)1786911371.656107905.2
 
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.