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

164 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
fanfics153517(None) 
fanfic1436311fanfic_
antics84621452_antics
fabrics1436092fabrics
fanatics1367182fanatics
fancies124018782fancies
fannies103415642fannies
manics103919932man_ics
panics103815362pan_ics
anils56326723_an_ils
anis45746463_an_i_s
antic75728863_antic_
antick124814583_antick
anticks134612253_anticks
antis55033313_anti_s
anvils9219713_anvils
asdics9439863_asdics
aspics104211563_aspics
attics84413283_attics
baffies153612943baffies
bandies104124863bandies
bandits103814793bandits
bankits133410153bankits
banties94324763banties
basics104915123ba_sics
candids113812693candids
candies104125613candies
canfuls1248423canfuls
canids95118133can_ids
cantic103920543cantic_
confits122811423confits
conics103920593con_ics
cynics13377363cyn_ics
dandies94121443dandies
danios7314603dan_ios
darics94314113da_rics
fabric1337833fabric_
facias113415803fa_cias
facies113921593fa_cies
fadeins1168503fadeins
faeries104118993faeries
fagins10513863fa_gins
fails85631483fa__ils
fairies103516043fairies
fairs85825443fa__irs
fakirs13468083fa_kirs
falsies103515013falsies
fanatic12610693fanatic_
fancied133310603fancied
fancier123412063fancier
fanciers13358083fanciers
fanciest133612713fanciest
fancifies1767083fancifies
fancify1834983fancify
fancily1538253fancily
fancy134615483fan__cy
fandoms13229473fandoms
fanegas1145713fanegas
fanes84639893fan__es
fanfare1336673fanfare
fanfares1436773fanfares
fanfold1485373fanfold
fanfolds15104073fanfolds
fangas105017193fan_gas
fangs96224073fan__gs
fanion94514323fan_ion
fanions103713073fanions
fanjets1734803fanjets
fanlike142610503fanlike
fanners103914653fanners
fanning113615073fanning
fanons96115213fan_ons
fanos85926503fan__os
fans76247373fan___s
fantails1139693fantails
fantods11177623fantods
fantoms12189153fantoms
fanums1137263fan_ums
fanwise1336633fanwise
fanzine1937123fanzine
fanzines2036913fanzines
faqirs18456033fa_qirs
faquirs1943863faquirs
farcies125317883farcies
farfals13268503farfals
farfels13348213farfels
fascias1258413fascias
fatties103018203fatties
fennecs12305693fennecs
finfish16268193finfish
finis86824263fin_i_s
flics105418363f__lics
francs114112193fran__cs
frantic12310363frantic_
frolics1236833frolics
fulfils1345723fulfils
fundic12389083fundic_
funfairs1442133funfairs
fungic12387813fungic_
funkias1435383funkias
funnies104113603funnies
fustics1279593fustics
ganoids939333ganoids
garlics1038013garlics
haffits1636193haffits
hankies143617763hankies
iambics13425643iambics
ionics84214483ion_ics
kaffirs17325553kaffirs
kafirs13306983ka_firs
kanjis1735963kanji_s
laics76419253la__ics
lanais6316793lanai_s
maffias15327283maffias
maffick2143523maffick
mafficks2243173mafficks
mafias113913573ma_fias
mafic125615463ma_fic_
magics115311613ma_gics
maniacs114313063maniacs
manias84029033man_ias
manic94629443man_ic_
maniocs113611443maniocs
mantic104120903mantic_
mantids103113623mantids
mantis83926033manti_s
mastics112614783mastics
nancies93516843nancies
nandins8312003nandins
nankins1159053nankins
nannies73015203nannies
pandies104224503pandies
pandits103914213pandits
panfish15229973panfish
panfries13149203panfries
panfuls1237173panfuls
panic93923903pan_ic_
pansies94521983pansies
panties94230933panties
quantics19276833quantics
raffias13237713raffias
randies84225663randies
ranids75118703ran_ids
ranis55235833ran_i_s
sanies63031953san_ies
santims9312603santims
santirs7312963santirs
sonics84315633son_ics
syndics1335703syndics
tactics1149323tactics
taffias13377413taffias
taffies133012693taffies
tafias93111963ta_fias
tannic82811473tannic_
tannins72813223tannins
tanrecs934823tanrecs
tansies74521243tansies
tonics83617863ton_ics
traffics1644183traffics
tunics83811263tun_ics
unfits93910293_unfits
waffies163611443waffies
zaffirs22375663zaffirs
zanies153219673zan_ies

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 Limit1340271646.86019537.5
3Display Results1641640.0762157.9
 (SQL Overall)1786911647.34224338.2
 
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.