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

141 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
fissure103678(None) 
fissured1235181fissured
fissures1136571fissures
assure6610772_assure
figure10258832fi_gure
fissate103010032fissate
fissile10269652fissile
fissural1143702fissural
fixture1734962fixture
fixure16256542fi_xure
insure63416602_insure
issue559212_issu_e
issuer646622_issuer
scissure1043272scissure
tissue637332tissu_e
assume897563_assume
assured858373_assured
assurer767793_assurer
assures7611403_assures
bisque17257843bisqu_e
bistre83815023bi_stre
censure92310603censure
closure9278483closure
coinsure1046933coinsure
dasyure1153823dasyure
disburse1186443disburse
diseur738843diseur_
diseurs839403diseurs
diseuse83110723diseuse
disposure1244973disposure
dispute1039083dispute
dissave1139413dissave
dissert83720693dissert
disserve1287443disserve
dissuade1065933dissuade
disturb1046233disturb
disuse74012843di_suse
ensure63416003_ensure
erasure736943erasure
facture12108933facture
failure1035753failure
feature1039853feature
fescue1137493fescu_e
fesse86116333fess__e
fiacre1137623fi_acre
fibre104812843fi__bre
fibster12146533fibster
figured12196473fi_gured
figurer11215863fi_gurer
figures11239113fi_gures
filature1145433filature
fique1739143fi_qu_e
fire76245593fi___re
fisher124917143fisher_
fishers134714723fishers
fishery16397733fishery
fisheye1644773fisheye
fishier13359853fishier
fission1038733fission
fissiped1444153fissiped
fissuring1344813fissuring
fistula1045503fistula
fistulae1144533fistulae
fixtures1835283fixtures
fixures17596063fi_xures
flexure1743413flexure
fossae95510373foss_ae
fossate10388603fossate
fosse86119463foss__e
friseur1033673friseur_
friseurs1133303friseurs
fusser94813773fusser_
fussers104210813fussers
fussier103610673fussier
future939563f_uture
gesture839243gesture
hirsute1084523hirsute
hisser94713793hisser_
hissers104112313hissers
hissier103410503hissier
immure1036033_immure
impure1038383_impure
injure133410863_injure
insured83714253_insured
insurer73312803_insurer
insures73117263_insures
inure54119053_i_nure
issued746723_issued
issuers746123_issuers
issues648803_issues
kisser104212453kisser_
kissers114211293kissers
leisure736693leisure
ligure7279473li_gure
lissome937583lissome
measure939033measure
miscue10412223miscu_e
misfire12229893misfire
misrule939353misrule
missile92815403missile
missive122413143missive
missort9314653missort
missuit9911303missuit
missus85312293missu_s
missuses10309683missuses
mistune9310653mistune
misuse83213643mi_suse
misuser93210443misuser
mixture1635413mixture
moisture1046653moisture
obscure1145333obscure
pasture9311463pasture
piastre9307893piastre
picture1158613picture
pismire1135353pismire
pisser84416383pisser_
pissers95014753pissers
posture9313253posture
pressure1039773pressure
rasure6311423_rasure
reassure847343reassure
reinsure837913reinsure
reissue745873reissu_e
reissuer854523reissuer
risque15227453risqu_e
rissole739783rissole
scissures1143323scissures
seisure738193seisure
sissier73711363sissier
sure45447413___sure
tissual745193tissual
tissued835583tissued
tissues737463tissues
tissuey1033663tissuey
tonsure758783tonsure
tressure846483tressure
tussore7317283tussore
tussur6357293tussur_
tussurs7356393tussurs
unsure62815413_unsure
vesture10310373vesture

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.436409841.7
2DLD Change Limit1340271416.51320578.4
3Display Results1411410.0502820.0
 (SQL Overall)1786911416.99925530.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.