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

125 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
swings10471445(None) 
sewings11369171sewings
sings65532701s_ings
slings74618011slings
stings76220181stings
swigs96213661swi_gs
swing96124841swing_
swinge105614381swinge
swinges113413421swinges
swingy13489871swingy
swinks134610651swinks
wings95727241_wings
agings86312672agings
askings12519172askings
awing96827322awing_
awnings11406712awnings
beings94613032beings
boings96416872boings
bowings133612002bowings
brings94618432brings
clings95716212clings
dings76331402_dings
doings84913182doings
dwines105013102dwines
dyings11478132dyings
flings106715282flings
goings84911522goings
icings9428452icings
kings105825562_kings
lawings113611472lawings
lings67135772_lings
lowings113710072lowings
lyings10488502lyings
mowings13328482mowings
owing96222722owing_
pings85830882_pings
rings65029172_rings
rowings113710362rowings
sains55639972sain_s
saints65122422saints
savings114412952savings
sawing104323812sawing_
sayings113610832sayings
seeings84411292seeings
seines65029902seines
sewing103819622sewing_
shines95028912shines
shins85131042shin_s
showings15246882showings
sidings94011452sidings
signs65516322s_igns
sines55954822s_ines
sing57544172s_ing_
singe65731132s_inge
singes74326852s_inges
sinhs86719602s_inhs
sinks95529182s_inks
sins46755272s_in_s
sinus55523852s_inus
sizings17378012sizings
skiings12295732skiings
skinks94511652skinks
skins94723462skin_s
slangs75615342slangs
sling66028802sling_
slinks104315152slinks
songs67725552s_ongs
sorings83817252sorings
sowing104222912sowing_
spines85132032spines
spins75327982spin_s
springs104415922springs
stangs75018162stangs
sting65330242sting_
stingo74212162stingo
stingos8459442stingos
stingy105213202stingy
stinks105616832stinks
stints65119762stints
strings84617132strings
suing65026362suing_
suints64617782suints
swags94921252sw_ags
swains94513952swain_s
swang95519722swang_
swanks134811562swanks
swans84625012swan_s
swifts12408172swifts
swig85818022swi_g_
swills94213352swills
swims105514142swi_ms
swine85625302swin_e
swingby16343892swingby
swingbys17282122swingbys
swinged123810792swinged
swinger113812562swinger
swingers123710422swingers
swingle113510562swingle
swingles12319542swingles
swinish1347202swinish
swink125116352swin_k
swipes114114332swipes
swirls94010132swirls
swiss86712902swi_ss
swives123915182swives
swung95610562swung_
things104914282things
tings65329192_tings
twangs10358092twangs
twigs96911172twi_gs
twines94717272twines
twinge104210392twinge
twinges11409442twinges
twins85118982twin_s
upswings1433002upswings
wigs84931252_wi_gs
winds95425602_winds
wines85546862_wines
wing86339222_wing_
wingy126521032_wingy
winks125325432_winks
winos84625042_winos
wins75949172_win_s
wrings104012972wrings
zings154620892_zings

Search took 4 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 Filter178691825510.1261418182.5
2DLD Change Limit825511253.37324474.1
3Display Results1251250.0304166.7
 (SQL Overall)1786911253.52950635.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.