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

211 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
whins11492233(None) 
chins105631461chins
hins76447991_hins
shins85131041shins
thins85826331thins
wains86930871wains
whens114618761whens
whids125413981whids
whigs125612641whigs
whims134515331whims
whin105225691whin_
whine116022811whine
whines125120101whines
whiny144915571whiny
whips134917081whips
whirs115218091whirs
whits115923821whits
wins75949171w_ins
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
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
swains94513952swains
tains54936322tains
theins95015422theins
thens85921832thens
thin76732392thin_
thine85026862thine
thing96622982thing
things104914302things
think125018802think
thinks134613362thinks
this76027382thi_s
tins45251302_tins
twains95811182twains
twins85118982twins
veins84620492veins
wahine123813012wahine
wahines133111172wahines
waifs115719872waifs
wails86631482wails
wain75840202wain_
wairs86424062wairs
waits88333522waits
wans76452272w_ans
warns87231002warns
weans85326742weans
weens85224052weens
weirs84316492weirs
wens76337932w_ens
whams135515642whams
whang124813382whang
whangs13439722whangs
whaps135115162whaps
whats117718992whats
wheens124610612wheens
when105723042when_
whenas124610462whenas
whets115019612whets
whews145114492whews
wheys145911552wheys
which163910082which
whid115418872whi_d
whiff17310062whiff
whiffs1835082whiffs
whig115516422whi_g
while115418692while
whiles124418012whiles
whilst1239142whilst
whim126220532whi_m
whimsy17375222whimsy
whined134715202whined
whiner124516632whiner
whiners134011572whiners
whiney155012642whiney
whinge134311542whinge
whinges143610632whinges
whinny15587492whinny
whip125521842whi_p
whipt135317422whipt
whir105519282whi_r
whirl114913822whirl
whirls124710532whirls
whirr114611192whirr
whirrs12408592whirrs
whish144512922whish
whisk154510142whisk
whisks16497352whisks
whist115322952whist
whists124613812whists
whit104834172whi_t
white114920302white
whitens13428732whitens
whites123919882whites
whity145513472whity
whiz195919942whi_z
whizz194210322whizz
whops135013932whops
whups134210002whups
whys137011662wh_ys
wigs84931252w_igs
win66456292w_in_
wind85533852w_ind
winds95425602w_inds
wine74953422w_ine
wines85546862w_ines
wing86339222w_ing
wings95727242w_ings
wink116435022w_ink
winks125325432w_inks
wino75933612w_ino
winos84625042w_inos
winy107034322w_iny
wis66552332w_i_s
wiss75630542w_iss
withins133511692withins
wits76044872w_its
wons74942042w_ons
wrens85016242wrens
wries85827742wries
wring95920712wring
wrings104012972wrings
writs86624382writs
wynns11517472wynns
wyns105717032w_yns
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.326548131.9
2DLD Change Limit538002111.51635488.1
3Display Results2112110.0633349.2
 (SQL Overall)1786912111.90593801.0
 
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.