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

140 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
rusks9581619(None) 
busks115521371busks
cusks114916051cusks
dusks105317251dusks
husks125015451husks
musks116119641musks
risks94917061risks
rucks114422051rucks
ruses56136581ruses
rusk85823311rusk_
rusts55026991rusts
tusks94915531tusks
asks85721212_asks
auks85525262au_ks
basks115621762basks
bisks115416802bisks
bosks115218852bosks
brisks124611402brisks
brusk114912432brusk_
bucks134824292bucks
bulks115920612bulks
bunks115125082bunks
buses75936012buses
busk105429222busk_
buss65134912bus_s
busts75227692busts
casks115720062casks
crucks144412582crucks
cruses88127712cruses
crusts84916542crusts
cusk105521632cusk_
cusps94913672cusps
cuss65430612cus_s
desks105913072desks
disks105417472disks
drunks11427512drunks
druses75517252druses
ducks124823212ducks
dunks105621192dunks
dusk95724152dusk_
dusky135213042dusky
dusts65923562dusts
frisks13479262frisks
fucks144419252fucks
funks125318912funks
fuses85628422fuses
fuss76027932fus_s
gucks123917302gucks
gunks104517722gunks
gusts65722792gusts
hucks144322172hucks
hulks125715482hulks
hunks125321452hunks
husk116021952husk_
husky156112562husky
junks164815972junks
justs124918262justs
lucks115723562lucks
lunks94822452lunks
lurks95218742lurks
lusts55022802lusts
lusus54813872lusus
masks115320532masks
mosks116117002mosks
mucks134622642mucks
murks114821732murks
muses75134302muses
musk104526192musk_
musky144715292musky
muss64933762mus_s
musts75527442musts
ousts55225702ousts
pucks134322102pucks
punks114822682punks
puses75532202puses
puss64830132pus_s
racks115028852racks
ranks95225732ranks
rases55447212rases
rasps74316662rasps
recks115625132recks
reeks94124032reeks
rests54935872rests
reuses66025522reuses
rhuses94911792rhuses
ricks115126132ricks
rinks94827102rinks
rises55244042rises
risk85724102risk_
risky126311522risky
risus54216392risus
rocks114626412rocks
rooks95325042rooks
roses56445772roses
rouses65436282rouses
rousts617016722rousts
rubes74928412rubes
rubs66133492ru_bs
rubus76415062rubus
ruck104728332ruck_
ruckus12407792ruckus
rudds74811702rudds
ruers515019412ruers
rues46044482ru_es
ruffs114516742ruffs
rugs56033682ru_gs
ruins55822032ruins
rules55234252rules
rumps95922292rumps
rums64833472ru_ms
runes55530222runes
rungs611819402rungs
runs46438082ru_ns
runts55927632runts
ruse45938932rus_e
rush76628182rus_h
rushes94724362rushes
rushy115414812rushy
rust45544912rus_t
rusty85221052rusty
ruths85714642ruths
ruts44541492ru_ts
sucks114523072sucks
suks85927122su_ks
sulks94818462sulks
suss45229302sus_s
tasks94917582tasks
trucks124711972trucks
trunks10429752trunks
truss54916922trus_s
trusts64714432trusts
tsks86410662_tsks
tucks114721122tucks
turks95320822turks
tusk85621632tusk_
uruses63616502uruses
uses44931112_uses
wuss75219332wus_s
yucks144717192yucks
yuks116418022yu_ks

Search took 3 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.313570897.8
2DLD Change Limit538001401.68631909.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911402.04587379.5
 
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.