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 “wiccans” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
wiccans143460(None) 
wiccan1335031wiccan_
wiccas1336541wicca_s
oilcans936812oilcans
siccan1037592siccan_
wicca1247252wicca__
wigans104511702wi_gans
witans93412932wi_tans
ashcans1235183ashcans
bicorns11338763bicorns
bicrons113410473bicrons
cancans11311873cancans
cans65050853___cans
clans75031013__clans
cyans105714813__cyans
dickens144410133dickens
dioxans1555313dioxans
discant103017253discant
discants112912023discants
divans104612393di_vans
diwans105110373di_wans
ficins113513983fi_cins
fincas113512073finca_s
firmans12238523firmans
fiscals1238003fiscals
glucans1045293glucans
glycans1344233glycans
hiccups1643223hiccups
icecaps1343863_icecaps
icons76516493_i_cons
incant82418503_incant
incants92012803_incants
lichens123510683lichens
ligans76817733li_gans
lignans8398853lignans
limans84816303li_mans
lochans1248833lochans
meccas1239493mecca_s
micas96823053mi_ca_s
microns113814783microns
minyans1237263minyans
niacins938543niacins
nicads938333ni_cads
oceans81211003_oceans
ocicats11137413ocicats
octans81411143_octans
oilcan837793oilcan_
pecans101515833_pecans
peccant13311733peccant
pechans14810503pechans
pians75126963pi__ans
picas94626523pi_ca_s
piccata1345703piccata
pitmans11188743pitmans
richens12349733richens
ricins83618703ri_cins
ricracs1136363ricracs
scans74625103__scans
siccing12319513siccing
sickens134411483sickens
silvans10308333silvans
simians959203simians
succahs1435323succahs
ticals83214713ti_cals
ticcing12308633ticcing
tictacs1145793tictacs
tincals93610643tincals
tipcats1137103tipcats
titans63414913ti_tans
titians72710453titians
toucans937583toucans
vicars11712263vi_cars
vicunas1285613vicunas
vincas113912453vinca_s
wangans1149503wangans
wans76452273w___ans
weans85326743w__eans
webcams1643073webcams
wiches144418753wi_ches
wickape1843723wickape
wickapes1943703wickapes
wickers164114703wickers
wickets164010943wickets
wicking173414773wicking
wickings18357183wickings
wicks144619363wi_c_ks
widens106212723wi_dens
wigan95114393wi_gan_
wigeons1136983wigeons
wigwags1543293wigwags
wigwams1643883wigwams
wildcats1444173wildcats
wincers123415363wincers
winces114819113winc_es
winceys15395523winceys
winches154714373winches
wincing133413903wincing
wins75949173wi___ns
wiseass1035823wiseass
witan83816503wi_tan_
witches152715793witches
withins133511693withins
wiverns13366963wiverns
wizens186110263wi_zens
wizzens18385483wizzens
womans114613653w_omans
yuccas13426553yucca_s
zircons1854963zircons

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271086.62620227.4
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.07825246.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.