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

260 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
misaim1031185(None) 
misaims11310111misaims
disarm9310472disarm
maim85831472m__aim
miasm91211092mi_asm
midair937982midair
minim97321592mi_nim
misact10316682misact
misadd1037162misadd
misaimed1338092misaimed
misate81222692misate
misclaim1445052misclaim
misdid10510562misdid
misfit112813832misfit
mishit112618192mishit
mislaid1039292mislaid
mislain9311242mislain
mislie83219152mislie
mislit83019692mislit
missaid10310292missaid
missis84417502missis
mistime11312612mistime
mosaic10311142mosaic
aim57858213___aim
assai5711543assai_
assail6610153assail
assais6711963assais
claim95616913_claim
diram84419473dira_m
disarms1039043disarms
disci85815023disci_
disclaim1345643disclaim
disdain938513disdain
dislimn1056103dislimn
distain8313783distain
distil73616433distil
fistic11812573fistic
fusain958643fusain
gisarme1044173gisarme
hispid1238173hispid
imam81718323_ima_m
imaum9139633_imaum
imbalm1246303imbalm
impair1035993impair
inarm7314423_inarm
isatin6412213_isatin
ism56322383_is__m
jism135514773jis__m
kilim11711883ki_lim
lissom837403lissom
litai55216363litai_
madam10316223mada_m
maid75537633m__aid
mail65543433m__ail
maims96321783m__aims
main65345503m__ain
mainsail1045153mainsail
mair66133763m__air
malm85129973m__alm
masa65034713masa__
masala8311813masala
masas75630413masa_s
mashie11315933mashie
masjid16187313masjid
massif11412533massif
mastic103119173mastic
mastix152310503mastix
maxim165216003m_axim
megrim1178043megrim
mesa67025483mesa__
mesas76823203mesa_s
mesial84818083mesial
mesian84315503mesian
mesic93617863mes_ic
miaou7513083mi_aou
miaow1058353mi_aow
miasma1097563miasma
miasmic1335743miasmic
miasms1097383miasms
miaul71612123mi_aul
mica86428243mica__
micas96823053mica_s
midairs1037193midairs
midi75628463mi_di_
midis85923403mi_dis
midrib1138233midrib
midship1546043midship
mikado1344513mikado
miladi938883miladi
miladis1049813miladis
milady1236613milady
milage93414123milage
milia72719563mi_lia
milium104712673milium
millime112511403millime
mim76048413m___im
mimic111414313mi_mic
mina65136903mina__
minae75627723mina_e
minas75434113mina_s
mini65634543mi_ni_
minima105512633mi_nima
minims104514803mi_nims
minis75432983mi_nis
minium106014413minium
minyanim1542963minyanim
miosis83615163miosis
miotic103715743miotic
mirage92313653mirage
miri66730363mi_ri_
mirin75023143mi_rin
mis58162613mis___
misacts1139353misacts
misadds1136303misadds
misaiming1437873misaiming
misalign1146433misalign
misally121111063misally
misaver1249813misaver
misbias1139073misbias
misbill1137023misbill
misbind1258263misbind
miscall1139643miscall
miscast11312403miscast
miscite11314383miscite
misclaims1544593misclaims
miscoin11311433miscoin
miscue10412223miscue
miscut10614813miscut
misdate101413963misdate
misdeem12217873misdeem
misdial1039643misdial
misdo85413183mis_do
mise66043573mis__e
misease92713043misease
miseat82925703miseat
miseats92815783miseats
misedit10311043misedit
miser75430403mis_er
misers85025703misers
misery114113543misery
mises74740563mis_es
misfaith1644543misfaith
misfed124113023misfed
misfile122611553misfile
misfire12229893misfire
misfits12279663misfits
misform1437513misform
misgave13298283misgave
misgive13339033misgive
mishap1338863mishap
mishaps1438713mishaps
mishits122513083mishits
misjoin1637693misjoin
miskal123710263miskal
miskals13369763miskals
miskick1435613miskick
mislay113510683mislay
mislays12349243mislays
misled94719313misled
mislies92922283mislies
mislike132914833mislike
mislive122812693mislive
mismade12129353mismade
mismake15139373mismake
mismark1536703mismark
mismate111415353mismate
mismet103722373mismet
misname11119483misname
miso67229893mis__o
misos76523293mis_os
mispage12310523mispage
mispaint121111893mispaint
mispart111113773mispart
mispen10312173mispen
misraise10410523misraise
misrate91319143misrate
miss65339413mis__s
missal84314903missal
missals93914423missals
missay114112143missay
missays124010253missays
missed94423603missed
missel85216523missel
misses85130873misses
misset85028153misset
missies93423983missies
missile92815403missile
missing103619073missing
mission9312743mission
missive122413143missive
missuit9911303missuit
missus85312293missus
missy105617563mis_sy
mist66154523mis__t
mistake131312613mistake
misted93625823misted
mister84728563mister
misterm114314513misterm
mistier93418713mistier
mistily122612343mistily
mistimed1339123mistimed
mistimes12612613mistimes
misting103623383misting
mistrain10311943mistrain
mists76633903mis_ts
misty106120453mis_ty
misuse83213643misuse
miswrit1249413miswrit
mitis75425983mi_tis
mohair1135203mohair
mohalim1446023mohalim
moirai886913moirai_
mosaics1138073mosaics
moshavim1882113moshavim
muscid11219833muscid
museum1037703museum
music94316403mus_ic
musjid16216953musjid
muskie123412533muskie
muskit122813253muskit
muslin8312213muslin
myasis114010463myasis
myiasis1245483myiasis
mysid11610683mys_id
mystic132711643mystic
nisei54214353nisei_
niseis63512023niseis
nisi45823243nis_i_
nizam16310253niza_m
passim10410283passim
pistil83915073pistil
psalm949273_psalm
resaid74517083resaid
resail64418733resail
rishi8311253rishi_
rishis9312453rishis
said55742113__said
sail45447163__sail
sain45551293__sain
shim95827843__shim
sim56553133__s_im
sisal54217733sisa_l
sisals63013573sisals
siskin1079783siskin
skim105322493__skim
slim66631953__slim
swim96221393__swim
tisane6311573tisane
unsaid7411833unsaid
victim1337683victim
visa76323873visa__
visaed104110503visaed
visage1049083visage
visaing11279333visaing
visard103910123visard
visas84317653visa_s
viscid1237473viscid
visit8320963vis_it
wisdom1235983wisdom
ziram163912893zira_m

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162605.23321539.5
3Display Results2602600.0932795.7
 (SQL Overall)1786912605.46932673.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.