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

194 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
misfire1222989(None) 
misfile122611551misfile
misfired14238541misfired
misfires132210581misfires
miffier1537022miffier
miscite11314382miscite
misfiled14278652misfiled
misfiles133110982misfiles
misfit112813832misfi_t
misfits12279662misfits
misform1437512misform
misgive13339032misgive
mislie83219152misli_e
mislike132914832mislike
mislive122812692mislive
missile92815402missile
missive122413142missive
mistier93418712mistier
mistime11312612mistime
pismire1135352pismire
rimfire1243792rimfire
afire86215913__afire
airfare1047243airfare
aspire8612123_aspire
bistre83815023bis_tre
bonfire1287063bonfire
bushfire1642603bushfire
desire7415303des_ire
disfigure1453173disfigure
dishier113613403dishier
dislike122913453dislike
emissive1345923emissive
fire76245593___fire
fishier13359853fishier
fissile10269653fissile
fissure1036783fissure
foxfire2042563foxfire
gunfire1134743gunfire
hissier103410503hissier
iffier1236763_iffier
infare9313083_infare
infirm1137043_infirm
inspire938253inspire
mashie11315933mashi_e
massier93615223massier
massive12289773massive
meshier123410853meshier
messier93412923messier
midair937993midair_
midairs1037203midairs
midlife13248303midlife
midline102315103midline
midsize1946393midsize
midwife16225523midwife
miffing16298403miffing
milkier133411163milkier
milliare1039153milliare
millier93716703millier
millime112511403millime
milline92519113milline
millirem1245693millirem
miltier93214963miltier
mincier113512473mincier
mingier103815293mingier
mintier93615993mintier
mire66748233m___ire
mirier83918363mi_rier
mirkier13319053mirkier
misaim10311853misai_m
misaimed1338093misaimed
misaims11310113misaims
misate81222693mis_ate
misaver1249813misaver
misbias1139083misbias
misbill1137033misbill
misbind1258273misbind
miscible1447673miscible
miscited13310423miscited
miscites12313783miscites
miscode12310413miscode
miscue10412223mis_cue
misdate101413963misdate
misdefine1545513misdefine
misdial1039643misdial
misdid10510573misdi_d
misdirect1444293misdirect
misdoer1048633misdoer
misdone10310863misdone
misdrew1335833mis_drew
misdrive1446683misdrive
mise66043583mis___e
misease92713043misease
miser75430403mis_er_
miserere1049273miserere
miseries10320403miseries
misers85025703mis_ers
misery114113543mis_ery
misfaith1644543misfaith
misfed124113023misf_ed
misfeed13389683misfeed
misfield14265913misfield
misfiring1536973misfiring
misfitted1544963misfitted
misformed1745243misformed
misforms1545893misforms
misframe1546973misframe
misgave13298283misgave
misgiven14245903misgiven
misgives14329293misgives
misgrew1335523mis_grew
misguide12145703misguide
mishit112618203mishi_t
mishits122513083mishits
miskick1435613miskick
mislies92922283mislies
misliked15319513misliked
misliker14319573misliker
mislikes143311833mislikes
mislit83019693misli_t
mislived14328783mislived
mislives132912153mislives
mismade12129353mismade
mismake15139373mismake
mismark1536703mismark
mismate111415353mismate
mismove1437083mismove
misname11119483misname
mispage12310523mispage
misparse1237733misparse
mispart111113783mispart
mispoise1248263mispoise
misprice1448133misprice
misprize2147543misprize
misraise10410523misraise
misrate91319143misrate
misrule939353misrule
missies93423983missies
missiles103015083missiles
missilry1344653missilry
missing103619073missing
mission9312743mission
missis84417503missi_s
missises103513693missises
missives133212843missives
missort9314653missort
mistake131312623mistake
mister84728563mister_
misterm114314513misterm
misters93927513misters
misthrew16124763misthrew
mistily122612343mistily
mistimed1339123mistimed
mistimes12612613mistimes
misting103623383misting
mistitle1038523mistitle
mistune9310653mistune
mistype14126523mistype
misuse83213643mis_use
misuser93210443misuser
misword1338413misword
miswrit1249413miswrit
miswrite1348923miswrite
misyoke1635823misyoke
mitier83620673mi_tier
mitre75522423mi__tre
mixture1635413mixture
moire71017323m__oire
moisture1046653moisture
mossier94413813mossier
mushier123813593mushier
muskie123412543muski_e
muskier134312733muskier
muspike1536043muspike
mussier93314363mussier
mustier94017963mustier
omissive1345103omissive
outfire1049713outfire
piscine11610973piscine
pismires1235883pismires
postfire1346273postfire
prefire124012813prefire
refire95419473_refire
respire9411543respire
rimfires1344203rimfires
riskier1138423riskier
shire84727133__shire
sire46150413__s_ire
sissier73711363sissier
spire75828693__spire
spitfire1343053spitfire
suspire937803suspire
visive1257873vis_ive
wildfire1542803wildfire
wispier12249403wispier

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 Limit1340271947.11018850.5
3Display Results1941940.0762552.6
 (SQL Overall)1786911947.59223536.7
 
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.