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

210 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
fissile1026965(None) 
missile92815401missile
fictile1238022fictile
fishily1637642fishily
fissate103010032fissate
fission1038732fission
fissiped1444152fissiped
fissure1036782fissure
fossil9379352fossil_
fossils10379012fossils
fusile94313492f_usile
fussily13267602fussily
misfile122611552misfile
missiles103015082missiles
missive122413142missive
rissole739782rissole
scissile1044622scissile
sessile739522sessile
aisle55223193ai_s_le
assize1538633_assize
bastile9313913bastile
besmile1137463besmile
bossily1237563bossily
cassine93817283cassine
cissies94116153cissies
dassie74615573dassi_e
disable10516433disable
disciple1346673disciple
dislike122913453dislike
dissave1139413dissave
disseise939853disseise
disseize1847183disseize
dissing94517683dissing
dissolve1246103dissolve
distil73616433distil_
distill83011323distill
distils83015803distils
dossil75110903dossil_
dossils8669773dossils
emissive1345923emissive
ensile62616473_ensile
facile112514883f_acile
falsie93513853falsi_e
farside1138603farside
fasciae1247523fasciae
fascicle1554633fascicle
fascine12510583fascine
feasible1376093feasible
febrile1237153febrile
feistily1445263feistily
felsite1039083felsite
fertile10311733fertile
fesse86116333fess__e
fessing113812863fessing
fesswise1442353fesswise
festive1339773festive
fibril1137163fibril_
fibrils1236843fibrils
fickle153912973fi_ckle
fictive1537023fictive
fiddle113613383fi_ddle
fierily1339023fierily
file75446643f___ile
fille84327403fi__lle
filmily1535733filmily
fimble133611753fi_mble
finable122213623finable
finagle11238313finagle
finale94116763fi_nale
finite9316823fi_nite
finlike14279063finlike
fipple13329063fi_pple
fireside1247003fireside
firstly1335643firstly
fiscal1139333fiscal_
fiscals1238003fiscals
fishable1637593fishable
fisheye1644773fisheye
fishier13359853fishier
fishing143913863fishing
fishkill1842143fishkill
fishlike18225873fishlike
fishline14237583fishline
fishpole1644053fishpole
fishwife2042293fishwife
fissility1544613fissility
fissioned1345523fissioned
fissions1138033fissions
fissipeds1542423fissipeds
fissured1235183fissured
fissures1136573fissures
fistic11812573fisti_c
fisting113818123fisting
fistula1045503fistula
fistulae1144533fistulae
fixable19218193fixable
fizzle17369713fi_zzle
flexile1735073flexile
flimsily1643283flimsily
flossie10337443flossi_e
flossily1434523flossily
fossae95510373foss_ae
fossate10388603fossate
fosse86119463foss__e
fossick16134733fossick
fossilise1243723fossilise
fossilize2143853fossilize
fragile1147843fragile
friskily1834503friskily
fusible1237023fusible
fusil84715323f_usil_
fusils93912343f_usils
fussier103610673fussier
fussing113611683fussing
fustily133111373fustily
futile93914953f_utile
gassily1137813gassily
gussie72910153gussi_e
hassle93711593hass_le
hessite1038993hessite
hirsle9159573hirs_le
hisself1335913hisself
hissier103410503hissier
hissies103915823hissies
hissing114213143hissing
hostile10312553hostile
inside7613453_inside
insole63515863_insole
isle45121703_i_s_le
issue559213_iss_ue
istle52214713_i_stle
jussive1734293jussive
kissable1436853kissable
kissing122911053kissing
lassie64917743lassi_e
lisle53916723li_s_le
lissome937583lissome
massive12289773massive
messily12298813messily
midsize1946393midsize
midsole1037813midsole
misbill1137033misbill
miscible1447673miscible
miscite11314383miscite
misfiled14278653misfiled
misfiles133110983misfiles
misfire12229893misfire
misgive13339033misgive
mislie83219153misli_e
mislike132914833mislike
mislive122812693mislive
misrule939353misrule
missable12311533missable
missal84314903missal_
missals93914423missals
missel85216523missel_
missels94614813missels
missies93423983missies
missileer1145583missileer
missilery1444553missilery
missilry1344653missilry
missing103619073missing
mission9312743mission
missis84417503missi_s
missises103513693missises
missives133212843missives
misstyle1345273misstyle
mistily122612343mistily
mistime11312613mistime
mistitle1038523mistitle
mussily12279773mussily
nitrile73011373nitrile
omissible1344093omissible
omissive1345103omissive
ossicle944483_ossicle
passible1237693passible
passive12239593passive
pensile92713543pensile
piscine11610973piscine
pismire1135353pismire
pissing103914803pissing
pistil83915073pistil_
pistils93314303pistils
pistole92414313pistole
possible1245813possible
prissily1346693prissily
rassle63813203rass_le
resile64627673_resile
rinsible1046293rinsible
risible937923risible
riskily1436413riskily
rissoles839113rissoles
sassily1038723sassily
simile83115633si_mile
sissier73711363sissier
sissies73716603sissies
smile74823923__smile
spile75230083__spile
stile54931573__stile
tassie66017023tassi_e
tensile72612733tensile
tipsily1236043tipsily
tissue637333tiss_ue
tussive1035303tussive
tussle637143tuss_le
virile9313433vi_rile
visible1236923visible
visive1257873vi_sive
wispily1535653wispily
wissing113212943wissing

Search took 9 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 Limit1340272107.96616824.9
3Display Results2102100.0802625.0
 (SQL Overall)1786912108.45221141.9
 
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.