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

181 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
mizzens1736612(None) 
mizens174610251mi_zens
mizzen16447951mizzen_
wizzens18385481wizzens
bizzes163910842bizze_s
dizens164911392di_zens
fizzers18357002fizzers
fizzes174512552fizze_s
middens11379372middens
miens76118302mi__ens
mildens10339932mildens
mispens11311072mispens
mittens9349882mittens
mizen164815272mi_zen_
mizzles17329492mizzles
wizens186110262wi_zens
wizzen17387202wizzen_
wizzes175110772wizze_s
biogens1038963biogens
bizes165923663bi_ze_s
bizones1837823bizones
brazens18418713brazens
buzzers17347173buzzers
buzzes165011173buzze_s
chazzens21253943chazzens
citizens1943983citizens
cozens176314923_cozens
cozzes164510893cozze_s
diazins1739183diazins
dickens144410133dickens
ditzes163212423ditze_s
dizen155214933di_zen_
dizzies16279753dizzies
dozens164612463_dozens
fezzes174910403fezze_s
fizzed18369443fizze_d
fizzer17369383fizze_r
fizzing19276403fizzing
fizzles18339063fizzles
frizzers19335103frizzers
frizzes18338183frizze_s
fuzzes175412253fuzze_s
givens10379733gi_vens
hazzans18215783hazzans
jazzers22324763jazzers
jazzes21347883jazze_s
khazens2332663khazens
kittens11347583kittens
lezzes14387833lezze_s
lichens123510683lichens
liens56525503li__ens
likens105613703li_kens
limens84618033li_mens
lindens839413lindens
linens64818393li_nens
lippens11328533lippens
listens74014133listens
livens94314893li_vens
maddens11359753maddens
maidens10349663maidens
maizes175115733maize_s
mamzers20409163mamzers
martens93714953martens
mavens114312973m_avens
mazers173917093m_azers
mazes165632173m_aze_s
mezes167719263m_eze_s
mezzos1635043mezz_os
miches134320733miche_s
mickeys18447943mickeys
microns113814783microns
midden104112853midden_
midges103516473midge_s
midgets113910253midgets
midlegs1156323midlegs
mien65028353mi__en_
mignons1037863mignons
mikes115129893mi_ke_s
mikrons13428413mikrons
mikvehs19111683mikvehs
milden94113153milden_
mildews13365883mildews
milers84625163mi_lers
miles74645073mi_le_s
milieus939803milieus
milkers134411613milkers
millers93621333millers
milles84526563mille_s
millets94216843millets
milnebs11113793milnebs
milreis937323milreis
milters93619083milters
mimeos104511543mi_meos
mimers105520183mi_mers
mimes95732023mi_me_s
mincers113714843mincers
minces104420803mince_s
minders103720113minders
miners84126633mi_ners
mines75651953mi_ne_s
minions93314623minions
minkes124618783minke_s
minters93822463minters
minuend1035383minuend
minuends1143893minuends
minuets9259853minuets
minxes154612983minxe_s
minyans1237263minyans
miocene1147923miocene
mioses84318853miose_s
mires75640883mi_re_s
mirins83918893mi_rins
mirzas1738173mirz_as
misers85025703mi_sers
mises74740563mi_se_s
mispen10312173mispen_
missels94614813missels
missend104411373missend
missends11368233missends
missense1037963missense
missent94318713missent
misses85130873misse_s
missets94516573missets
mistend103812523mistend
mistends11419593mistends
misters93927503misters
miters84328773mi_ters
mites75141803mi_te_s
mithers123516733mithers
mitogens1146973mitogens
mitres83922073mitre_s
mitten83914093mitten_
mixers154513563mi_xers
mixes147224403mi_xe_s
mizuna1734303mi_zuna
mizunas1843693mizunas
mizzenmast225923mizzenmast
mizzle16279993mizz_le
mizzled18327633mizzled
mizzling19255443mizzling
mizzly19256103mizz_ly
moistens10268773moistens
momzers20367133momzers
moreens939963moreens
morgens10310463morgens
mudhens1335103mudhens
muezzins1842663muezzins
mullens93611313mullens
muzzlers18245203muzzlers
muzzles17299683muzzles
pigpens1235503pigpens
pinkens13419643pinkens
pizzas1646983pizz_as
pizzles17329273pizzles
quizzers2542943quizzers
quizzes2435573quizze_s
razzes144910063razze_s
richens12349733richens
ripens85012173ri_pens
ritzes154812943ritze_s
rozzers1535633rozzers
sickens134411483sickens
siemens938413siemens
sirens65318153si_rens
sithens1039383sithens
sizers155215813si_zers
sizes146727763si_ze_s
sizzlers16274753sizzlers
sizzles15349633sizzles
smidgens12325643smidgens
tizzies15287893tizzies
vixens16286203vi_xens
viziers19336203viziers
whizzers2233423whizzers
whizzes2134713whizze_s
widens106212723wi_dens
winzes184313053winze_s
wizen175813863wi_zen_
wizes174723343wi_ze_s
zazens1435833_zazens
zizzles14307093zizzles

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.1561145455.1
2DLD Change Limit1340271816.70319995.1
3Display Results1811810.0603016.7
 (SQL Overall)1786911816.91925826.1
 
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.