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

187 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
twins8511898(None) 
tains54936321tains
thins85826321thins
tins45251301t_ins
twains95811181twains
twigs96911171twigs
twin76023081twin_
twine85822361twine
twines94717271twines
twiny116012811twiny
twits86015791twits
wins75949171_wins
ains46158882_ains
amins75534312amins
awing96827322awing
awns75324432aw_ns
ayins85321612ayins
bins66548242_bins
brins75533972brins
cains75334302cains
chins105631462chins
coins75834552coins
dins56652042_dins
djins1368452djins
dwine95616142dwine
dwines105013102dwines
fins75849092_fins
foins85523382foins
gains65729512gains
gins55543952_gins
grins65427222grins
gwine95513662gwine
hins76447992_hins
ins35945602__ins
iwis77117002iwi_s
jins115635012_jins
joins125818412joins
kains96125642kains
kins85747902_kins
lins47059052_lins
loins56728422loins
mains75635092mains
owing96222722owing
owns76819582ow_ns
pains75138282pains
peins76128062peins
pins65558452_pins
pyins105815862pyins
quins144819852quins
rains55140232rains
rawins95617622rawins
reins56234562reins
rewins95020822rewins
rins46153192_rins
ruins55822032ruins
sains55639972sains
shins85131042shins
sins46755272_sins
skins94723462skins
spins75327982spins
stains64923652stains
steins64818342steins
swains94513952swains
swans84625012swans
swigs96213662swigs
swims105514142swims
swine85625302swine
swing96124842swing
swings104714452swings
swink125116352swink
swinks134610652swinks
swiss86712902swiss
tails55634192tails
tain45548072tain_
taint55542282taint
taints64520532taints
takins105117402takins
tans46154812t_ans
tarns56433952tarns
tawing104521552tawing
teens56227482teens
teind6213612teind
teinds738262teinds
tens45647412t_ens
terns55226872terns
tewing103914822tewing
theins95015422theins
thens85921832thens
thin76732382thin_
thine85026852thine
thing96622962thing
things104914282things
think125018792think
thinks134613352thinks
this76027382thi_s
tics65729632t_ics
ties45248312t_ies
tils45739612t_ils
tin36362172t_in_
tine45855132t_ine
tines54848422t_ines
ting56139892t_ing
tings65329192t_ings
tint46758862t_int
tints56030922t_ints
tiny76134632t_iny
tips66436762t_ips
tis37056642t_i_s
tits46145032t_its
toils54527492toils
toits55327472toits
tons46553052t_ons
toons55027532toons
towies93521192towies
towing103823192towing
towns86018882towns
toxins133314282toxins
trains64725342trains
trans54933042trans
triens65417542triens
tries55742812tries
trigs65423062trigs
trims75021472trims
trine54734602trine
trines64132562trines
trios55528092trios
trips74923362trips
tuis44829642tui_s
tuns45138662t_uns
turns55623232turns
twaes86513662twaes
twain86313622twain_
twang94511852twang
twangs10358092twangs
twas76824082tw_as
twats86616602twats
tweens9489842tweens
twice104711122twice
twier84713292twier
twiers95410162twiers
twig87615772twi_g
twill85612722twill
twills9489792twills
twined104413122twined
twiner94012592twiner
twiners10459632twiners
twinge104210392twinge
twinges11409442twinges
twinset1039372twinset
twirl85011942twirl
twirls9478122twirls
twirp10468942twirp
twirps11415012twirps
twist86820982twist
twists9549752twists
twit76329062twi_t
twixt155512482twixt
twos76718022tw_os
tyin76424002tyin_
tying96019832tying
veins84620492veins
wains86930862wains
wans76452262_wans
wens76337932_wens
whins114922332whins
wigs84931252_wigs
win66456292_win_
wind85533852_wind
winds95425602_winds
wine74953422_wine
wines85546862_wines
wing86339222_wing
wings95727242_wings
wink116435022_wink
winks125325432_winks
wino75933612_wino
winos84625042_winos
winy107034322_winy
wis66552332_wi_s
wiss75630542_wiss
wits76044872_wits
wons74942042_wons
wyns105717032_wyns
yins75335122_yins
ywis105313102ywi_s
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.0931921408.6
2DLD Change Limit538001871.61033416.1
3Display Results1871870.0632968.3
 (SQL Overall)1786911871.766101184.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.