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

221 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
misavers134805(None) 
misaver1249811misaver_
minivers1337472minivers
misalters1136902misalters
misdoers1137102misdoers
misers85025702mis__ers
mislayers1445932mislayers
mistakers15117072mistakers
misters93927502mis_ters
misusers10348072misusers
savers93825922__savers
aivers94822323ai__vers
assayers1144843assayers
avers85127313___avers
beavers124417323_beavers
behavers16205613behavers
bilayers13296913bilayers
bisters93922603bis_ters
bravers124715523_bravers
cadavers1435863cadavers
cavers115026833__cavers
clavers124314893_clavers
cleavers13398863cleavers
cravers124416543_cravers
dialers83614293di_alers
diapers104713893di_apers
diasters92913173diasters
dilaters92513053dilaters
disablers1255803disablers
disarmers1246943disarmers
disasters1039143disasters
disavowers1743023disavowers
disavows1544043disavows
discovers1538153discovers
disfavors1643263disfavors
dissaves1239413dissave_s
dissevers1386863dissevers
distaves12311393distave_s
divers105024963di__vers
enslavers1243883enslavers
essayers1133563essayers
fishers134714723fis_hers
fivers124420923fi__vers
givers104817713gi__vers
gravers114515263_gravers
havers124721483__havers
heavers133717193_heavers
hissers104112313his_sers
imagers10107753_imagers
impalers12226963impalers
isomers9310043_isomers
issuers746123_issuers
jivers164515643ji__vers
kissers114211293kis_sers
lavers94526363__lavers
leavers103717783_leavers
lifesavers1651763lifesavers
lispers94514323lis_pers
listers74026523lis_ters
livers94927823li__vers
macers105321273m__acers
makers123921733m__akers
managers112911003managers
masers84623453m__asers
mashers124621053mas_hers
maskers133913833mas_kers
masquers19195703masquers
massagers1245503massagers
masters94628923mas_ters
maters85032383m__aters
mavens114312973m__avens
mazers173917093m__azers
meaners94415243m_eaners
meisters103313843meis_ters
menacers12279303menacers
metamers1249623metamers
micawbers1842063micawbers
midairs1037193mida_irs
middlers123410193middlers
mikvehs19111683mi_kvehs
milages103114403milage_s
milers84625163mi__lers
milkers134411613mi_lkers
millers93621333mi_llers
milliers102611893milliers
milters93619083mi_lters
mimers105520183mi__mers
minarets1048833minarets
mincers113714843mi_ncers
minders103720113mi_nders
miners84126633mi__ners
minglers113011283minglers
miniver1238393miniver_
minsters103813913minsters
minters93822463mi_nters
miradors1146833miradors
mirages102213533mirage_s
misacts1139353misa_cts
misadds1136303misa_dds
misagent11410723misagent
misagents1246793misagents
misaims11310113misa_ims
misalter1038343misalter_
misandry1443863misandry
misate81222693misate__
misaverred1642443misaverred
misaward1464593misaward
misawards1563793misawards
misbehavers2151863misbehavers
miscallers1444303miscallers
miscues11312393miscue_s
misdates111113623misdate_s
misdealers1344613misdealers
misdeeds12276813misdeeds
misdeems13255653misdeems
misdoer1048633misdoer_
misdoes10312493misdoe_s
miseases102614343misease_s
misenters1139523misenters
miser75430403mis__er_
miserere1049273miserere
misereres1148183misereres
misery114113543mis__ery
mises74740563mis__e_s
misevent1349223misevent
misevents1456003misevents
misfeeds14315623misfeeds
misfires132210583misfires
misgave13298283misgave__
misgives14329293misgive_s
misgovern1543053misgovern
misgoverns1652053misgoverns
misguess1134643misguess
mishanters1544973mishanters
mishears1338323mishears
misinfers1445473misinfers
misinters1138163misinters
miskeeps1644163miskeeps
mislabels13114313mislabels
mislabors1344503mislabors
mislayer1337503mislayer_
misleaders1345203misleaders
mislies92922283mislie_s
mislikers15317053mislikers
mislives132912153mislive_s
mismakes16129883mismake_s
mismates121114553mismate_s
mismeets12297733mismeets
mismoves1537293mismove_s
misnames12119883misname_s
misnomers1346183misnomers
misorders1245863misorders
mispages13311183mispage_s
mispens11311073mis_pens
misrates101318233misrate_s
misrefers1445363misrefers
missels94614813mis_sels
misses85130873mis_se_s
missets94516573mis_sets
misshapers1743393misshapers
missies93423983missie_s
missives133212843missive_s
missteers1135913missteers
missteps12156143missteps
mistaker14109323mistaker_
mistakes141213403mistake_s
mister84728563mis_ter_
misterm114314513mis_term
misterms123711333mis_terms
mistier93418713mistier_
mistress10310703mistress
misuser93210443misuser_
misuses93216023misuse_s
miterers10219683miterers
miters84328773mi__ters
mithers123516733mi_thers
mixers154513563mi__xers
moaners92813553m_oaners
moshers124017843mos_hers
mossers94116193mos_sers
movers115117193m__overs
musers84719093mus__ers
mushers124016433mus_hers
musters94522493mus_ters
palavers1337993palavers
pavers115021823__pavers
piasters102912803piasters
pishers123815753pis_hers
pissers95014753pis_sers
preavers13910263preavers
quavers19309003_quavers
ravers94628183__ravers
reavers108320743_reavers
rievers104311453ri_evers
risers64624783ris__ers
riskers114011993ris_kers
rivers94626543ri__vers
sabers85224733__sabers
sakers104125433__sakers
salvers103916003__salvers
saver84831253__saver_
saves85838633__save_s
savors95616103__savors
sawers94620163__sawers
sayers94221593__sayers
severs94121123__severs
shavers134115093_shavers
silvers104714033si_lvers
sisters73721573sis_ters
sivers95324153__sivers
slavers103716503_slavers
timesavers1552163timesavers
tisanes7311853tisane_s
visages1138693visage_s
visiters1137403visiters
vitamers1334673vitamers
vivers124717363vi__vers
wavers125022473__wavers
weavers133714463_weavers
wishers133215213wis_hers
wivers125320803wi__vers

Search took 9 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.1731032896.0
2DLD Change Limit1461622218.50017195.5
3Display Results2212210.1861188.2
 (SQL Overall)1786912218.85920170.6
 
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.