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

106 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
fissured123518(None) 
fissure1036781fissure_
fissures1136571fissures
assured858372_assured
figured12196472fi_gured
fissiped1444152fissiped
fissural1143702fissural
insured83714252_insured
issued746722_issu_ed
tissued835582tissu_ed
assumed1065293_assumed
assure6610773_assure_
assureds984493_assureds
assurer767793_assurer
assures7611403_assures
bistered112913333bistered
bistred103311853bi_stred
censured11248913censured
closured11266353closured
coinsured1245513coinsured
disbursed1365763disbursed
disputed1238353disputed
dissaved1337313dissaved
dissed85220183diss__ed
disserted11109813disserted
disserved14107003disserved
dissuade1065933dissuade
dissuaded1265433dissuaded
disturbed13195583disturbed
disused93211033di_sused
ensured83512943_ensured
favoured1533963favoured
featured1237683featured
fessed104515063fess__ed
festered122512113festered
fibered1337643fi_bered
figure10258833fi_gure_
figurer11215863fi_gurer
figures11239113fi_gures
filtered12259043filtered
fingered13128333fingered
fired94829743fi___red
fished134316313fi_s_hed
fissate103010033fissate_
fissile10269653fissile_
fissioned1345523fissioned
fissipeds1542423fissipeds
fissuring1344813fissuring
fisted104218703fi_s_ted
fixture1734963fixture_
fixtures1835283fixtures
fixure16256543fi_xure_
fixures17596063fi_xures
floured11289873f_loured
fostered122210453fostered
fussed104613803fuss__ed
gestured1036993gestured
hissed104114453hiss__ed
immured1235063_immured
injured15339063_injured
insure63416603_insure_
insureds9277613_insureds
insurer73312803_insurer
insures73117263_insures
inured73114813_i_nured
issue559213_issu_e_
issuer646623_issu_er
issuers746123_issuers
issues648803_issu_es
kissed114412853kiss__ed
leisured934763leisured
measured1136463measured
miscued1239293miscu_ed
misfired14238543misfired
misruled1137083misruled
missed94423603miss__ed
missorted1247033missorted
missuited1257023missuited
missuses10309683missuses
mistuned1157723mistuned
misused104111283mi_sused
obscured1343893obscured
pastured1138233pastured
pictured1346573pictured
pissed94816933piss__ed
postured1139493postured
pressured1237333pressured
reassured1046103reassured
reinsured1036983reinsured
reissued944903reissu_ed
scissored1243033scissored
scissure1043273scissure_
scissures1143323scissures
sistered92612803sistered
soured74921863__soured
tissue637333tissu_e_
tissues737463tissu_es
tissuey1033663tissu_ey
tonsured976383tonsured
unassured1084353unassured
uninsured1044873uninsured
unissued934683unissu_ed
unsoured9310063unsoured
vestured1237463vestured
visored1138143vi_sored
wissed104114643wiss__ed

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621066.96620982.2
3Display Results1061060.0333212.1
 (SQL Overall)1786911067.42224075.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.