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

151 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
misaimed133809(None) 
mistimed1339121mistimed
disarmed1238642disarmed
maimed114812662m__aimed
misacted1338672misacted
misadded1335752misadded
misaim10311852misaim__
misaims11310112misaim_s
miscited13310422miscited
misclaimed1744262misclaimed
misfiled14278652misfiled
misfired14238542misfired
misliked15319512misliked
mislived14328782mislived
misnamed13127592misnamed
misraised1268312misraised
mistime11312612mistime_
mistimes12612612mistimes
aimed85626053___aimed
assailed945323assailed
beslimed1335013beslimed
claimed12298833_claimed
disabled1248713disabled
disarmer1138033disarmer
disclaimed1644413disclaimed
disdained1246023disdained
disliked14288553disliked
dislimned1344623dislimned
distained1139603distained
fissiped1444153fissiped
gisarme1044173gisarme_
gisarmes1144433gisarmes
imbalmed1543293imbalmed
impaired1335143impaired
inarmed10268673_inarmed
liaised837113li_aised
mailed95326753m__ailed
maimer104514593m__aimer
melamed1249633mela_med
meseemed1343963meseemed
miaoued1034583mi_aoued
miaowed1333883mi_aowed
miauled1036663mi_auled
midsized2144733midsized
midwifed18233933midwifed
midwived18263553midwived
millime112511403millime_
millimes122411373millimes
milliped1337383milliped
mimed105622733m___imed
misadd1037163misa__dd
misadvised1742633misadvised
misaiming1437873misaiming
misaligned1443583misaligned
misallied1246543misallied
misalter1038343misalter
misate81222693misa_te_
misatoned1246693misatoned
misaver1249813misa_ver
misaward1464593misaward
misbiased1444843misbiased
misbilled1445173misbilled
misbind1258273misbi_nd
miscalled1447443miscalled
miscite11314383miscite_
miscites12313783miscites
miscoded1437983miscoded
miscoined1448443miscoined
miscued1239293mis_cued
misdated121211123misdated
misdeed113211053mis_deed
misdeemed1544603misdeemed
misdialed1345513misdialed
misdid10510573misdi__d
misedited1346783misedited
misfed124113023mis__fed
misfeed13389683mis_feed
misfield14265913misfield
misfile122611553misfile_
misfiles133110983misfiles
misfire12229893misfire_
misfires132210583misfires
misfitted1544963misfitted
misformed1745243misformed
misframed1745623misframed
misgauged1443703misgauged
misgive13339033misgive_
misgiven14245903misgiven
misgives14329293misgives
misguided14144653misguided
misjoined1945453misjoined
miskicked1744063miskicked
mislaid1039303mislai__d
misled94719313mis__led
mislie83219153misli_e_
mislies92922283misli_es
mislike132914833mislike_
misliker14319573misliker
mislikes143311833mislikes
mislive122812693mislive_
mislives132912153mislives
mismarked1845243mismarked
mismated131111333mismated
mismet103722373mis__met
mismoved1635653mismoved
misname11119483misname_
misnames12119883misnames
misnomer1247143misnomer
mispaged1438243mispaged
mispainted1545013mispainted
misparsed1446253misparsed
misparted1437263misparted
mispled12310463mis_pled
mispoised1446803mispoised
mispriced1646423mispriced
misprized2346603misprized
misraise10410523misraise_
misraises1149933misraises
misrated111315383misrated
misrhymed2042743misrhymed
misruled1137083misruled
missaid10310303missai__d
missed94423603mis__sed
missies93423983missi_es
missile92815403missile_
missiles103015083missiles
missioned1248603missioned
missises103513693missises
missive122413143missive_
missives133212843missives
missuited1257023missuited
misted93625823mis__ted
mistermed1438363mistermed
mistier93418713misti_er
mistitled1246283mistitled
mistrained1347583mistrained
mistuned1157723mistuned
mistyped1685173mistyped
misused104111283mis_used
misvalued1544283misvalued
misyoked1834623misyoked
mosaicked1842483mosaicked
psalmed1234503_psalmed
resailed93613063resailed
sailed74327763__sailed
sained75424243__sained
slimed94915123__slimed
unaimed102812493_unaimed
visaed104110503visa__ed
visaged1235683visa_ged
visited1168773vis_ited

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.453394461.4
2DLD Change Limit1461621516.59322169.3
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.10925135.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.