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

237 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
misaims1131011(None) 
misaim10311851misaim_
disarms1039042disarms
maims96321792m__aims
miasms1097382mi_asms
midairs1037202midairs
minims104514812mi_nims
misacts1139352misacts
misadds1136302misadds
misaimed1338092misaimed
misbias1139082misbias
misclaims1544592misclaims
misfits12279662misfits
mishits122513082mishits
mislies92922282mislies
missies93423982missies
missis84417502missi_s
mistime11312612mistime
mistimes12612612mistimes
mosaics1138072mosaics
aims67738193___aims
assails769093assails
assais6711963assai_s
cissies94116153cissies
claims105211573_claims
dirams94413703dira_ms
disarm9310473disarm_
disclaims1444853disclaims
disdains1037913disdains
dislimn1056103dislimn
dislimns1144813dislimns
dismiss1038153dismiss
distains9413603distains
distils83015803distils
fusains1038363fusains
gisarme1044173gisarme
gisarmes1144433gisarmes
hissies103915823hissies
imams91511113_ima_ms
imaums10106303_imaums
imbalms1334553imbalms
impairs1135823impairs
inarms8410093_inarms
isatins7310773_isatins
isms66213473_is__ms
jisms14458003jis__ms
kilims1277903ki_lims
madams11310943mada_ms
maids86327153m__aids
mails76037783m__ails
maim85831493m__aim_
mains75635113m__ains
mainsails1144853mainsails
mairs76228303m__airs
malms95021553m__alms
masalas9312073masalas
masas75630413masa__s
mashies12318253mashies
masjids17175403masjids
massifs1237743massifs
mastics112614783mastics
maxims17399673m_axims
megrims1276103megrims
mesas76823203mesa__s
meseems1165603meseems
miaous8511693mi_aous
miaows1145473mi_aows
miasm91211093mi_asm_
miasma1097563mi_asma
miasmas1167743miasmas
miasmic1335743miasmic
miauls8178713mi_auls
micas96823053mica__s
midair937993midai_r
middies113116153middies
midis85923423mi_di_s
midribs1235513midribs
midships1645693midships
mikados1444683mikados
miladies1139923miladies
miladis1049823miladis
milages103114403milages
millime112511403millime
millimes122411373millimes
mimics1289363mi_mics
minas75434113mina__s
minim97321603mi_nim_
minima105512653mi_nima
minis75432993mi_ni_s
miniums113910223miniums
minnies93617363minnies
miosis83615163miosi_s
miotics112710653miotics
mirages102213533mirages
mirins83918903mi_rins
misact10316693misa_ct
misadd1037163misa_dd
misaiming1437873misaiming
misalign1146433misalign
misaligns1244773misaligns
misallies1148383misallies
misally121111063misally
misate81222693misa_te
misaver1249813misaver
misavers1348063misavers
misbill1137033misbill
misbills1246083misbills
misbind1258273misbind
misbinds1345163misbinds
miscalls1239003miscalls
miscasts1238353miscasts
miscite11314383miscite
miscites12313783miscites
misclaim1445063misclaim_
miscoins12311083miscoins
miscues11312393miscues
miscuts1139183miscuts
misdates111113633misdates
misdeems13255653misdeems
misdial1039643misdial
misdials1137503misdials
misdid10510573misdi_d
misdoes10312493misdoes
miseases102614343miseases
miseats92815793miseats
misedits1147963misedits
miseries10320403miseries
misers85025703mis_ers
mises74740563mis__es
misfaith1644543misfaith
misfaiths1742463misfaiths
misfile122611553misfile
misfiles133110983misfiles
misfire12229893misfire
misfires132210583misfires
misfit112813833misfi_t
misforms1545893misforms
misgive13339033misgive
misgives14329293misgives
mishaps1438723mishaps
mishit112618203mishi_t
misjoins1736913misjoins
miskals13369773miskals
miskick1435613miskick
miskicks1544763miskicks
mislaid1039303mislai_d
mislain9311243mislai_n
mislays12349243mislays
mislie83219153misli_e
mislike132914833mislike
mislikes143311833mislikes
mislit83019693misli_t
mislive122812693mislive
mislives132912153mislives
mismakes16129883mismakes
mismarks1645893mismarks
mismates121114563mismates
misname11119483misname
misnames12119883misnames
misos76523293mis__os
mispages13311183mispages
mispaint121111893mispaint
mispaints13106183mispaints
misparts12108173misparts
mispens11311073mispens
misraise10410523misraise
misraises1149933misraises
misrates101318243misrates
miss65339433mis___s
missaid10310303missai_d
missals93914433missals
missays124010253missays
missels94614813missels
misses85130873mis_ses
missets94516573missets
missile92815403missile
missiles103015083missiles
missing103619073missing
mission9312743mission
missions10311903missions
missises103513693missises
missive122413143missive
missives133212843missives
missuits1078023missuits
missus85312293mis_sus
mistakes141213413mistakes
misterms123711353misterms
misters93927513misters
mistier93418713mistier
mistiest103018313mistiest
mistily122612343mistily
mistimed1339123mistimed
misting103623383misting
mistrains11511353mistrains
mists76633903mis__ts
misuses93216023misuses
mitis75425993mi_ti_s
mittimus1243023mittimus
mohairs1234953mohairs
mosaic10311143mosai_c
muscids12187973muscids
museums1134573museums
musics103911783mus_ics
musjids17185713musjids
muskies133614673muskies
muskits13278563muskits
muslins9312213muslins
myasis114010473myasi_s
myiasis1245493myiasi_s
mysids1246563mys_ids
mystics14279103mystics
niseis63512023nisei_s
nizams1735413niza_ms
pistils93314303pistils
psalms1045673_psalms
resails74616743resails
rishis9312453rishi_s
saids65328863__saids
sails55738103__sails
sains55639973__sains
shims104422553__shims
sims65737183__s_ims
sisals63013573sisa_ls
siskins1159583siskins
sissies73716603sissies
skims114517203__skims
slims75423653__slims
swims105514143__swims
tisanes7311853tisanes
victims1436003victims
visages1138693visages
visaing11279333visaing
visards11328153visards
visas84317653visa__s
visits9311423vis_its
wisdoms1335453wisdoms
zirams17438643zira_ms

Search took 7 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.403443402.0
2DLD Change Limit1340272376.28321331.7
3Display Results2372370.0763118.4
 (SQL Overall)1786912376.76226425.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.