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

143 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
wiccan133503(None) 
siccan1037591siccan
wicca1247251wicca_
wiccans1434601wiccans
wiccas1336541wiccas
oilcan837792oilcan
wigan95114392wi_gan
witan83816502wi_tan
aidman92410623aidman
airman82414223airman
ashcan1135843ashcan
bacca111012183bacca_
baccae12119703baccae
bicorn103610103bicorn
bicron103710773bicron
buccal1248243buccal
can57760143___can
cancan10314103cancan
circa9311403circa_
clan65633923__clan
coccal9310223coccal
cyan96419623__cyan
dicta84915633dicta_
dioxan1465773dioxan
discant103017253discant
divan96114843di_van
diwan95712553di_wan
ficin103516723fi_cin
finca104714503finca_
fincas113512073fincas
firman112211343firman
fiscal1139333fiscal
glucan936183glucan
glycan1234903glycan
hiccup1554393hiccup
hitman112710223hitman
icecap1245223_icecap
iceman1037853_iceman
icon66922043_i_con
incant82418503_incant
lichen114012743lichen
ligan67920283li_gan
lignan75510323lignan
liman75921603li_man
lochan1139093lochan
mecca1139933mecca_
meccas1239493meccas
mica86428253mi_ca_
micas96823053mi_cas
micra96214973micra_
micron103714283micron
midcap1336473midcap
minyan1138173minyan
niacin8310223niacin
nicad8312613ni_cad
ocean71212963_ocean
ocicat101412813ocicat
octan71313483_octan
oilcans936813oilcans
oilman839483oilman
pecan91919033_pecan
peccant13311733peccant
pechan13511543pechan
pian66136093pi__an
pica85831493pi_ca_
pical95524373pi_cal
picas94626523pi_cas
piccata1345703piccata
pickax2135913pickax
pitman102412123pitman
richen113812513richen
ricin74620213ri_cin
ricrac1037013ricrac
rictal83113183rictal
scan65530453__scan
sicced11489653sicced
siccing12319513siccing
sicken124615253sicken
silvan92810153silvan
simian8811163simian
socman1039813socman
succah1336643succah
tical76021493ti_cal
ticced11438443ticced
ticcing12308633ticcing
tictac1036563tictac
tincal83913363tincal
tinman82411143tinman
tipcat10312653tipcat
titan53318173ti_tan
titian62512663titian
titman82711003titman
toucan838193toucan
vicar10513863vi_car
vicuna11115903vicuna
vinca105315163vinca_
vincas113912453vincas
wan66761943w___an
wangan10311223wangan
wean75734353w__ean
webcam1545543webcam
wich125724743wi_c_h
wiches144418753wiches
wick135726303wi_c_k
wickape1843723wickape
wicked164317413wicked
wicker154518673wicker
wicket155318943wicket
wicking173414773wicking
wicks144619363wi_cks
wicopy1634033wicopy
widen94717973wi_den
wigans104511703wi_gans
wigeon1037223wigeon
wigwag1443723wigwag
wigwam1544723wigwam
wilco1039443wilc_o
wildcat1346293wildcat
wimmin1336153wimmin
win66456293wi___n
wince105220883winc_e
winced124415343winced
wincer115018193wincer
winces114819113winces
wincey144110383wincey
winch135016663winc_h
wincing133413903wincing
wingman1336383wingman
wireman1237843wireman
wirra83210823wirra_
wisha114910853wisha_
witans93412933wi_tans
witch134517563witc_h
witchy17468593witchy
withal1238933withal
within123611383within
wivern12409283wivern
wizen175813863wi_zen
wizzen17387203wizzen
woman105818003w_oman
yucca12467443yucca_
yuccas13426553yuccas
zircon1754953zircon

Search took 6 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127161435.71619719.4
3Display Results1431430.0502860.0
 (SQL Overall)1786911435.89230327.7
 
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.