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

134 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
whims13451533(None) 
hims95230971_hims
shims104422551shims
whams135515641whams
whids125413981whids
whigs125612641whigs
whim126220531whim_
whimsy17375221whimsy
whins114922331whins
whips134917081whips
whirs115218091whirs
whits115923821whits
ahimsa1134782ahimsa
ahis76135382ahi_s
aims67738182_aims
brims94721622brims
chams126028502chams
chias104625522chias
chics123920942chics
chimb144813562chimb
chimbs153910302chimbs
chime125322592chime
chimes134922572chimes
chimp145216472chimp
chimps155713662chimps
chins105631462chins
chips125721252chips
chirms135113982chirms
chis95933312chi_s
chits105424572chits
chums125015832chums
dims75435022_dims
ghis85020162ghi_s
glims87417672glims
hams96446132_hams
hems95534942_hems
hies74842832_hies
him86247662_him_
hins76447992_hins
hips96433702_hips
his66359502_hi_s
hiss75629212_hiss
hits75545132_hits
hums96831422_hums
khis117017982khi_s
maims96321792maims
nims66226882_nims
ohias84415572ohias
ohms95514032oh_ms
oxims14107642oxims
phis95724902phi_s
prims95425932prims
rims65936302_rims
shams105829412shams
shies86136552shies
shim95827862shim_
shins85131042shins
ships105123772ships
shits84731172shits
shivs115018802shivs
sims65737172_sims
skims114517192skims
slims75423652slims
swims105514142swims
thins85826332thins
this76027382thi_s
trims75021472trims
vims95423312_vims
waifs115719872waifs
wails86631482wails
wains86930872wains
wairs86424062wairs
waits88333522waits
warms107726852warms
weirs84316492weirs
wham125321692wham_
whamo135511262whamo
whaps135115162whaps
whats117718992whats
whelms14377572whelms
whens114618762whens
whets115019612whets
whews145114492whews
wheys145911552wheys
which163910082which
whid115418872whi_d
whiff17310062whiff
whiffs1835082whiffs
whig115516422whi_g
while115418692while
whiles124418012whiles
whilst1239142whilst
whimsey18373892whimsey
whin105225692whi_n
whine116022812whine
whines125120102whines
whiny144915572whiny
whip125521842whi_p
whipt135317422whipt
whir105519282whi_r
whirl114913822whirl
whirls124710532whirls
whirr114611192whirr
whirrs12408592whirrs
whish144512922whish
whisk154510142whisk
whisks16497352whisks
whist115322952whist
whists124613812whists
whit104834172whi_t
white114920302white
whites123919882whites
whity145513472whity
whiz195919942whi_z
whizz194210322whizz
whom127018182whom_
whomp155011322whomp
whomps16457602whomps
whomso1434132whomso
whops135013932whops
whump154910042whump
whumps16427092whumps
whups134210002whups
whys137011662wh_ys
wigs84931252w_igs
wimp115521522w_imp
wimps125213802w_imps
wins75949172w_ins
wis66552332w_i_s
wiss75630542w_iss
wits76044872w_its
worms105320762worms
wries85827742wries
writs86624382writs

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 Limit538001341.44037361.1
3Display Results1341340.0462913.0
 (SQL Overall)1786911341.782100275.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.