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

305 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
fiscal113933(None) 
fiscals1238001fiscals
dismal92412242dismal
distal73615772distal
faecal11359812faecal
fascial1258302fascial
faucal11339962faucal
fecal105119212f_ecal
festal94213562festal
filial93013252filial
final83922032fi_nal
finca104714502finca_
fincas113512072fincas
finial92814182finial
finical1239702finical
fisc96819762fisc__
fiscally1646072fiscally
fiscs105311882fisc_s
focal104917672f_ocal
mescal104113492mescal
miscall1139652miscall
miskal123710262miskal
missal84314902missal
pascal10812372pascal
pical95524372pi_cal
rascal8511122rascal
sisal54217732sis_al
tical76021492ti_cal
tincal83913372tincal
visual938802visual
apical10913903apical
basal75722283bas_al
biaxal1536093biaxal
bifocal1445373bifocal
binal75323823bi_nal
buccal1248243buccal
byssal1134993byssal
caecal103713733caecal
casual81112873casual
cecal94619113_cecal
cercal10314123cercal
cicala10310063ci_cala
cicale10314503ci_cale
circa9311403circa_
cisco95112133cisc_o
ciscos104711133ciscos
citral81113893citral
coccal9310223coccal
costal85419513costal
crissal937413crissal
cuspal1037883cuspal
decal85523233_decal
dial55935073di__al
disbar938513disbar
disc76123243disc__
discant103017263discant
discard11310213discard
discase102912863discase
disced104914653disced
disci85815023disc_i
disco85616073disc_o
discos94915213discos
discs85316263disc_s
discus94512113discus
dismals102010243dismals
dismay12229473dismay
dispel9310323dispel
distil73616433distil
dossal75510303dossal
ducal84816423_ducal
epical10413393epical
escar74011993_escar
facial113615633facial
fallal93612693fallal
farfal123410193farfal
fasces114914543fasces
fascia1148703fascia
fasciae1247523fasciae
fascias1258413fascias
fatal84819373f_atal
faucals12326563faucals
faucial1257323faucial
faunal94711593faunal
feal713940423f__eal
fecial114714623fecial
feral85424653f_eral
ferial94621253ferial
fescue1137493fescue
fetal85623373f_etal
fetial95716193fetial
feudal1037683feudal
fiacre1137623fiacre
fiar76427343fi__ar
fiaschi1542793fiaschi
fiasco11104923fiasc_o
fiascos12124743fiascos
fiat76646653fi__at
fibril1137163fibril
fibula11258053fibula
fice95737123fi_c_e
fices106031163fi_ces
fiche134616743fi_che
fichu134810663fi_chu
ficin103516723fi_cin
fickle153912973fi_ckle
fickly18318533fi_ckly
fico95824603fi_c_o
ficus105015493fi_cus
fiducial1443263fiducial
fiesta938123fiesta_
fiestas1038433fiestas
figural1145243figural
fil65447153fi___l
fila74729143fi_la_
filar84819293fi_lar
filch134813323filc_h
fill75540203fi__ll
finale94116763fi_nale
finals94316163fi_nals
finch135416973finc_h
finials103210153finials
firman112211353firman
fiscalist1446573fiscalist
fish106926283fis__h
fishable1637593fishable
fished134316313fished
fisher124917143fisher
fishes125221343fishes
fishily1637643fishily
fishmeal1642663fishmeal
fishtail1443983fishtail
fishway1943813fishway
fishy146011663fis_hy
fissate103010033fissate
fissile10269653fissile
fissural1143703fissural
fist76248433fis__t
fisted104218703fisted
fistful1365903fistful
fistic11812573fistic
fists85527543fis_ts
fistula1045503fistula
fitch134816873fitc_h
fitchy17437623fitchy
fitful1256333fitful
floral94313813floral
foal76630923f__oal
foetal9311883foetal
fontal9313143fontal
formal113215213formal
fossa85812633fossa_
fossae95510373fossae
fossas94610703fossas
fossil9379353fossil
foveal1237703foveal
fracas11311993fracas
fractal1237623fractal
frugal1036393frugal
fugal95613033f_ugal
fungal10388733fungal
fusel85218493fus_el
fusil84715323fus_il
gimbal11228813gimbal
gimmal11247513gimmal
gingal81010153gingal
hiatal9310203hiatal
hiemal11339513hiemal
ideal65716393_ideal
ileal56118083_ileal
ilial55317843_ilial
instal6712193instal
isba61310883_isba_
isbas71010403_isbas
ischial1246423_ischial
jacal14313703_jacal
jingal1498593jingal
kismat123011683kismat
laical8312323laical
lascar868573lascar
lienal63912793lienal
lineal65616033lineal
listel64214743listel
local74820273_local
meniscal1246203meniscal
mescals112911573mescals
mesial84818083mesial
mezcal19367853mezcal
miasmal1176743miasmal
mica86428263mi_ca_
micas96823053mi_cas
midcap1336473midcap
mimical1339233mimical
misact10316693misact
miscalls1239003miscalls
miscast11312423miscast
miscue10412223miscue
miscut10614823miscut
misdeal1037663misdeal
misdial1039643misdial
miseat82925713miseat
mishap1338873mishap
miskals13369773miskals
mislay113510683mislay
missals93914433missals
missay114112143missay
missel85216523missel
mistral91013643mistral
mitral81314323mitral
musca9311763musca_
muscae10410673muscae
muscat10314663muscat
musical1139553musical
nasal56217593nas_al
nasial6413283nasial
nicad8312613ni_cad
nicol71113293ni_col
nidal65217113ni_dal
nival84915773ni_val
nonfiscal1444543nonfiscal
oilcan837793oilcan
pascals11610013pascals
paschal14157243paschal
pial65636713pi__al
pibal95217323pi_bal
pica85831503pi_ca_
picas94626523pi_cas
picul95015363pi_cul
pineal84817693pineal
pinnal84814283pinnal
pipal95118353pi_pal
piscary1437423piscary
piscinal1285843piscinal
pisco96314983pisc_o
piscos105112593piscos
pistil83915073pistil
pistol83313333pistol
plical10411683plical
postal84317533postal
rascals959663rascals
rescale93215483rescale
reseal64819653reseal
rial45938103ri__al
rictal83113193rictal
ritual6310623ritual
rival85216503ri_val
riyal84413433ri_yal
sal36462883__s_al
scab85926713__scab
scad75725773__scad
scag76626893__scag
scald84818123__scald
scale74629143__scale
scall74420373__scall
scalp95217983__scalp
scaly104718723__scaly
scam85932353__scam
scan65530453__scan
scar66434203__scar
scat65848373__scat
seal45654373__seal
seismal937303seismal
sial45938843__sial
siccan1037593siccan
signal73711483signal
sisals63013573sis_als
sulcal8311283sulcal
thecal113310313thecal
tibial849843tibial
ticals83214713ti_cals
tidal64516453ti_dal
timbal102510753timbal
tincals93610653tincals
tineal66216173tineal
tipcat10312653tipcat
tissual745193tissual
tussal6288323tussal
unseal63315473unseal
upscale11136323upscale
usual5310183_usual
vasal85516293vas_al
vassal979243vassal
vesical12159813vesical
vestal94615573vestal
vial76731103vi__al
vicar10513863vi_car
vinal85725813vi_nal
vinca105315163vinca_
vincas113912453vincas
vineal94814753vineal
viral86419593vi_ral
visa76323883vis_a_
visas84317653vis_as
visceral1344683visceral
viscid1237473viscid
viscus11428503viscus
vista85416603vista_
vistas94513273vistas
visuals1036863visuals
vital84819673vi_tal
vocal104715643_vocal
wicca1247253wicca_
wiccan1335033wiccan
wiccas1336543wiccas
wisha114910853wisha_
withal1238933withal

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.406440125.6
2DLD Change Limit1127163055.04622337.7
3Display Results3053050.1232479.7
 (SQL Overall)1786913055.57532052.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.