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

188 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
mislain931124(None) 
mislaid1039301mislaid
disdain938512disdain
distain8313782distain
misaim10311852mis_aim
misalign1146432misalign
misclaim1445062misclaim
miscoin11311432miscoin
misjoin1637692misjoin
mislay113510682misla_y
mislaying1557912mislaying
mislays12349242mislays
mislearn1045342mislearn
mislie83219152misl_ie
mislit83019692misl_it
mislying1437842mislying
mispaint121111892mispaint
misplan1147772mispla_n
missaid10310302missaid
mistrain10311942mistrain
muslin8312212musl_in
slain54923572__slain
villain1038482villain
abstain947253abstain
blain75421793__blain
cisplatin1344713cisplatin
destain8412083destain
disclaim1345643disclaim
disdains1037913disdains
disjoin1547643disjoin
dislimn1056103dislimn
distains9413603distains
distrain9412243distrain
eiswein1043503eiswein
elain55324703__elain
explain1667043explain
fusain958643fus_ain
histamin1387043histamin
inlaid7310143_inlaid
isatin6412213_isatin
island738533_island
isling71213883_isl_ing
lain46146283___lain
main65345523m___ain
maintain1077723maintain
malkin122913153m_alkin
marlin84220903marl_in
melanin9310893m_elanin
merlin83916683merl_in
mesian84315503mesia_n
messan83912063messa_n
midair937993mi_dair
midbrain1343923midbrain
midland1136613midland
midline102315103midl_ine
migraine1157863migraine
miladi938883mi_ladi
miladis1049823mi_ladis
milady1236613mi_lady
milage93414123mi_lage
milden94113153mi_lden
milding113615453mi_lding
milia72719573mi_l_ia
milking143712763mi_lking
millage103112753millage
milline92519113mi_lline
milling103223683mi_lling
million91813143million
millrun944183millrun
milting103619123mi_lting
minikin13258983minikin
minyan1138173minya_n
mirin75023153mi__rin
misact10316693mis_act
misadd1037163mis_add
misaims11310113mis_aims
misaligns1244773misaligns
misally121111063misally
misate81222693mis_ate
misbegin1344673misbegin
misbias1139083misbias
misbind1258273mis_bind
miscall1139653miscall
miscast11312423miscast
misclaims1544593misclaims
misclass1246843misclass
miscoins12311083miscoins
miscuing1338733miscuing
misdate101413963misdate
misdating131010663misdating
misdial1039643misdial
misdid10510573mis_did
misdoing1238803misdoing
misdrawn1444343misdrawn
misease92713043misease
miseat82925713misea_t
miseaten10310773miseaten
miseating121215433miseating
miseats92815783miseats
misedit10311043misedit
misfaith1644543misfaith
misfit112813833mis_fit
misgave13298283misgave
mishap1338873misha_p
mishaps1438723mishaps
mishit112618203mis_hit
misjoins1736913misjoins
miskal123710263miska_l
miskals13369763miskals
mislabel1296173mislabel
mislabor1244503mislabor
mislayer1337503mislayer
mislead10419973mislead
misleading1446833misleading
misleads11358543misleads
mislearns1144523mislearns
mislearnt1195553mislearnt
misled94719313misl_ed
mislies92922283mislies
mislike132914833mislike
misliking1637113misliking
mislive122812693mislive
misliving1546983misliving
mismade12129353mismade
mismake15139373mismake
mismaking18118023mismaking
mismark1536703mismark
mismate111415353mismate
mismating141211823mismating
misname11119483misname
misnaming1447423misnaming
mispage12310523mispage
mispaging1537803mispaging
mispaints13106183mispaints
mispart111113783mispart
mispen10312173mis_pen
misplace1437553misplace
misplacing1745913misplacing
misplans1238863misplans
misplant12410763misplant
misplay1436383mispla_y
misplaying1845553misplaying
misplays1555543misplays
mispoint121012363mispoint
misprint12912973misprint
misraise10410523misraise
misrate91319143misrate
misrating121014853misrating
missal84314903missa_l
missals93914423missals
missay114112143missa_y
missaying1537633missaying
missays124010253missays
missing103619073mis_sing
mission9312743mission
missis84417503mis_sis
missuit9911303missuit
mistake131312623mistake
mistaken14147833mistaken
mistaking1699693mistaking
misthink1745433misthink
misting103623383mis_ting
mistrains11511353mistrains
misunion1084943misunion
misusing1138893misusing
miswrit1249413miswrit
mosaic10311143mos_aic
moulin8313283moul_in
mullein9278563mullein
murrain937763murrain
muslins9312213musl_ins
myelin1138973myel_in
oilskin1144473oilskin
outlain71212613outlain
plain74823303__plain
sain45551293__s_ain
simlin8311733siml_in
sirloin747593sirloin
siskin1079783sis_kin
stain55727943__stain
sustain738773sustain
swain84919053__swain
villains1138013villains
villainy1444883villainy
villein1036753villein
violin9311983viol_in
visaing11279333vis_aing
vitrain1038943vitrain

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 Limit1340271886.97019229.1
3Display Results1881880.0603133.3
 (SQL Overall)1786911887.43624030.5
 
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.