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

222 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
thins8582633(None) 
chins105631461chins
hins76447991_hins
shins85131041shins
tains54936321tains
theins95015421theins
thens85921831thens
thin76732391thin_
thine85026861thine
thing96622981thing
things104914301things
think125018801think
thinks134613361thinks
this76027381thi_s
tins45251301t_ins
twins85118981twins
whins114922331whins
ahing98928352ahing
ahis76135382ahi_s
ains46158882_ains
amins75534322amins
ayins85321612ayins
bins66548252_bins
brins75533972brins
cains75334302cains
chains114819702chains
chias104625522chias
chics123920942chics
chin96934742chin_
china105022482china
chinas115119402chinas
chine105231722chine
chines115029172chines
chink145321592chink
chinks155817572chinks
chino105823312chino
chinos115018692chinos
chints115117832chints
chips125721252chips
chis95933312chi_s
chits105424572chits
coins75834552coins
dins56652042_dins
djins1368452djins
ethics11169282ethics
ethions1038482ethions
fins75849092_fins
foins85523382foins
gains65729512gains
ghis85020162ghi_s
gins55543952_gins
grins65427222grins
hens75642572_hens
hies74842832_hies
hims95230972_hims
hin67559562_hin_
hind85529752_hind
hinds96721472_hinds
hint77455742_hint
hints87330622_hints
hips96433702_hips
his66359502_hi_s
hisn79620932_hisn
hiss75629212_hiss
hits75545132_hits
hons77350782_hons
huns76136932_huns
ins35945602__ins
jins115635012_jins
joins125818412joins
kains96125642kains
khans124615172khans
khis117017982khi_s
kins85747912_kins
lins47059052_lins
loins56728422loins
mains75635112mains
ohias84415572ohias
ohing96018812ohing
pains75138282pains
peins76128062peins
phis95724902phi_s
phons105221142phons
pins65558452_pins
pyins105815862pyins
quins144819852quins
rains55140232rains
reins56234562reins
rhino84614322rhino
rhinos94411122rhinos
rins46153192_rins
ruins55822032ruins
sains55639972sains
shies86136552shies
shims104422552shims
shin75634312shin_
shine85533092shine
shines95028912shines
shiny115122142shiny
ships105123772ships
shits84731172shits
shivs115018802shivs
shuns85018142shuns
sins46755272_sins
skins94723462skins
spins75327982spins
stains64923652stains
steins64818342steins
tahini939892tahini
tahinis1048012tahinis
tails55634192tails
tain45548072tain_
taint55542282taint
taints64520532taints
takins105117402takins
tans46154822t_ans
tarns56433952tarns
teens56227482teens
teind6213612teind
teinds738262teinds
tens45647412t_ens
terns55226872terns
than76128772than_
thane86122532thane
thanes94918982thanes
thank125817802thank
thanks134313132thanks
thaws116515462thaws
thegns10547432thegns
thein85919022thein_
theine94814922theine
theines104013232theines
theirs94610352theirs
then78429692then_
thews117416192thews
thick145613352thick
thicks154511992thicks
thief114516302thief
thigh12410122thigh
thighs1346632thighs
thill85918732thill
thills95515382thills
thinly1238672thinly
thio77225412thi_o
thiol87616042thiol
thiols95112762thiols
thir76420542thi_r
third95912492third
thirds10438602thirds
thirl85416822thirl
thirls95012062thirls
thirst9312252thirst
thong95014182thong
thongs104611192thongs
thorns95314102thorns
thous86017262thous
thrips11299012thrips
thuds95110132thuds
thugs95611992thugs
thunk124911852thunk
thunks13459032thunks
thus76721472th_us
tics65729632t_ics
ties45248312t_ies
tils45739612t_ils
tin36362172t_in_
tine45855132t_ine
tines54848422t_ines
ting56139902t_ing
tings65329202t_ings
tint46758862t_int
tints56030922t_ints
tiny76134632t_iny
tips66436762t_ips
tis37056642t_i_s
tits46145042t_its
toils54527492toils
toits55327472toits
tons46553052t_ons
toons55027532toons
towns86018882towns
toxins133314282toxins
trains64725342trains
trans54933042trans
triens65417542triens
tries55742812tries
trigs65423062trigs
trims75021472trims
trine54734602trine
trines64132562trines
trios55528092trios
trips74923362trips
tuis44829642tui_s
tuns45138662t_uns
turns55623242turns
twains95811182twains
twigs96911172twigs
twin76023082twin_
twine85822362twine
twines94717272twines
twiny116012812twiny
twits86015792twits
tyin76424002tyin_
tying96019842tying
veins84620492veins
wains86930872wains
whens114618762whens
whids125413982whids
whigs125612642whigs
whims134515332whims
whin105225692whin_
whine116022812whine
whines125120102whines
whiny144915572whiny
whips134917082whips
whirs115218092whirs
whits115923822whits
wins75949172_wins
withins133511692withins
yins75335122_yins
zeins144715392zeins
zins135735002_zins

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.313570897.8
2DLD Change Limit538002221.54634799.5
3Display Results2222220.0633523.8
 (SQL Overall)1786912221.92292971.4
 
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.