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

132 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
tusks9491553(None) 
busks115521371busks
cusks114916051cusks
dusks105317251dusks
husks125015451husks
musks116119641musks
rusks95816191rusks
tasks94917581tasks
tsks86410661t_sks
tucks114721121tucks
turks95320821turks
tusk85621631tusk_
asks85721212_asks
auks85525262au_ks
basks115621762basks
bisks115416802bisks
bosks115218852bosks
bucks134824292bucks
bulks115920612bulks
bunks115125082bunks
buses75936012buses
busk105429222busk_
buss65134912bus_s
busts75227692busts
casks115720062casks
cusk105521632cusk_
cusps94913672cusps
cuss65430612cus_s
desks105913072desks
disks105417472disks
ducks124823212ducks
dunks105621192dunks
dusk95724152dusk_
dusky135213042dusky
dusts65923562dusts
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
risks94917062risks
rucks114422052rucks
ruses56136582ruses
rusk85823312rusk_
rusts55026992rusts
sucks114523072sucks
suks85927122su_ks
sulks94818462sulks
suss45229302sus_s
tacks115430132tacks
talks94322692talks
tanks94624732tanks
task85326652task_
tass45640572tas_s
teaks94222902teaks
tests56530192tests
thunks13459032thunks
ticks115823292ticks
torsks10549122torsks
toss45637972tos_s
touses64229672touses
treks96016852treks
trucks124711972trucks
trunks10429752trunks
truss54916922trus_s
trusts64714432trusts
tsk75814732t_sk_
tubas75119582tubas
tubes74826452tubes
tubs65430062tu_bs
tuck104626572tuck_
tufas85314382tufas
tuffs115118262tuffs
tufts85713272tufts
tugs56231672tu_gs
tuis44829642tu_is
tules54532792tules
tumps95420792tumps
tunas54224122tunas
tunes55332192tunes
tungs65520622tungs
tuns45138662tu_ns
tupiks1235492tupiks
tups65628762tu_ps
turds65021692turds
turfs84620442turfs
turk86125862turk_
turns55623242turns
turps74918732turps
tush74523902tus_h
tushes94319472tushes
tushy114212992tushy
tusked114112152tusked
tusker104212192tusker
tuskers113710042tuskers
tusses64921242tusses
tussis6379952tussis
tuts45838452tu_ts
tutus55214812tutus
tuxes124316042tuxes
uses44931112_uses
wuss75219332wus_s
yucks144717192yucks
yuks116418022yu_ks

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.296603685.8
2DLD Change Limit538001321.61033416.1
3Display Results1321320.0304400.0
 (SQL Overall)1786911321.93692299.1
 
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.