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

119 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
swill8341737(None) 
shill85325331shill
sill45545151s_ill
skill94316721skill
spill74821161spill
still54922081still
swell84815981swell
swills94213361swills
swirl84514141swirl
twill85612721twill
will75737511_will
aswirl935092aswirl
bill67239942_bill
brill74819952brill
chill105619872chill
dill55239972_dill
drill64718262drill
dwell9519852dwell
fill75540192_fill
frill84917562frill
gill56336182_gill
grill64617892grill
hill76439492_hill
ill37437092__ill
jill116430262_jill
kill85533172_kill
krill94213642krill
maill74420792maill
mill66541482_mill
nill45634302_nill
pill65339462_pill
prill74117942prill
quill148413772quill
rill45140902_rill
sail45447162sai_l
sails55738102sails
sall44544682s_all
sawbill1255292sawbill
sawmill1244072sawmill
scall74420372scall
scilla8310942scilla
scull75315762scull
sell45840612s_ell
shall85024052shall
shell84424122shell
shiel811023772shiel
shills94519612shills
shily115222012shily
shrill94712302shrill
sial45938832s_ial
sild55030582s_ild
silk85529322s_ilk
sills55135992s_ills
silly84527622s_illy
silo46037912s_ilo
silt46558192s_ilt
skell94915832skell
skills104313922skills
skirl96012912skirl
skull94812032skull
slily85820032slily
small74016262small
smell74916232smell
smile74823922smile
snell54517302snell
soil46138832soi_l
soils55327982soils
spall74919302spall
spell75020302spell
spiel74623912spiel
spile75230082spile
spills84717462spills
spilt75532222spilt
squill1537232squill
stall54722352stall
stile54931572stile
stills64118572stills
stilly93714092stilly
stilt54831982stilt
stull54916272stull
swail86217162swail
swails94913122swails
swale85221592swale
swells93913982swells
swift116818052swift
swig85818022swi_g
swigs96213662swigs
swilled113611832swilled
swiller103211662swiller
swim96221402swi_m
swims105514142swims
swine85625302swine
swing96124842swing
swink125116352swink
swipe105217082swipe
swiple11379232swiple
swirls94010132swirls
swirly12439252swirly
swish115114822swish
swiss86712902swiss
swith115917402swith
swive115316192swive
swivel12369322swivel
thill85918732thill
till45941202_till
trill55122932trill
twills9489792twills
twirl85011942twirl
vill75235072_vill
wall76236102_wall
well75832042_well
wild85126512_wild
wile75944372_wile
wills84528962_wills
willy115321912_willy
wilt76246292_wilt
wily106428812_wily
yill75628972_yill
zill135727612_zill

Search took 3 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 Limit538001191.89028465.6
3Display Results1191190.0333606.1
 (SQL Overall)1786911192.01688636.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.