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

179 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
yurt7643504(None) 
curt67051711curt
hurt77142571hurt
yurta86014251yurta
yurts87216531yurts
airt45757782airt
art38679142_art
aunt46553652aunt
aura45836252aura
blurt77625622blurt
bort65960962bort
brut66537962brut
bunt65850852bunt
bur55744692bur_
bura66139532bura
burb85334672burb
burd75534262burd
buret77444012buret
burg74930362burg
burl64937182burl
burn65636422burn
burnt75230322burnt
burp85028882burp
burr65631232burr
burs65847422burs
burst75332242burst
bury95633592bury
bust65947782bust
but55963022bu_t
butt65143742butt
cart66570342cart
court75532762court
cult66541152cult
cunt66243672cunt
cur56841982cur_
curb86732222curb
curd77634982curd
cure66149122cure
curet75447642curet
curf97538782curf
curl66035052curl
curn66731882curn
curr65429652curr
curs65645542curs
curst74931022curst
cut57957662cu_t
dart55857872dart
dirt55550382dirt
duct75735462duct
duet56446262duet
duit56241582duit
dunt55746872dunt
dura55232112dura
dure56341812dure
durn56127622durn
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
lyart85121882lyart
mart66865972mart
mort66758832mort
mura65633292mura
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
runt46647982runt
rust45544912rust
rut35560522ru_t
sort46264812sort
spurt77227982spurt
sturt56028962sturt
suet46754822suet
suit45649872suit
sura45740292sura
surd56433812surd
sure45447412sure
surf76039312surf
tart47566182tart
tort46967462tort
tuft76929512tuft
turd56027622turd
turf75334052turf
turk86125862turk
turn46330382turn
tut36758092tu_t
urb55731102_urb
urd46427042_urd
urn35731462_urn
urp56426392_urp
ut28647032_u_t
vert77249372vert
wart77866082wart
wert79749822wert
wort76654752wort
wurst85122992wurst
yar67253832yar_
yard85633252yard
yare75636942yare
yarn75230042yarn
yerk116222082yerk
yet66960692y_et
yett76434492yett
yird87018982yird
yirr76513572yirr
yirth116513752yirth
yogurt1037822yogurt
yore76335942yore
your78623432your_
yourn87512772yourn
yours85217872yours
yuan76120012yuan
yuca95716722yuca
yuch125818532yuch
yuck136423532yuck
yuga85615422yuga
yuk106725602yu_k
yuks116418022yuks
yule75725142yule
yum86132822yu_m
yup86031702yu_p
yups96121602yups
yutz167519882yutz

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.0762351197.4
2DLD Change Limit298721790.98630296.1
3Display Results1791790.0463891.3
 (SQL Overall)1786911791.108161273.5
 
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.