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

214 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
menhirs123591(None) 
menhir1136781menhir_
memoirs1136802memoirs
menders103818802menders
mentors9314992mentors
senhors103512132senhors
aethers103614943aethers
amenders11288353amenders
amentias1039413amentias
benchers153611013benchers
benders104021063benders
bennies93917313bennies
bennis84314803benni_s
benzins1838693benzins
bestirs9311133bestirs
censers94313903censers
censors93611843censors
centers94420603centers
deairs74013783de_airs
denars74621433den_ars
deniers84515183deniers
denies74729643den_ies
denims95214323den_ims
dentils84115583dentils
dentins83419223dentins
devoirs1175783devoirs
emenders11319033emenders
emirs76116163_e_mirs
enders74324053_enders
engird8126973_engird
engirds995053_engirds
engirt71112613_engirt
enters64425643_enters
entire61617703_entire
entires71517783_entires
enviers1036993_enviers
envies9314053_envies
enviro936303_enviro
enviros1034913_enviros
ephors11311403_ephors
ethers94518413_ethers
ethics11169283_ethics
fencers123810623fencers
fenders113717263fenders
genders93616783genders
genies75324943gen_ies
genips9469943gen_ips
genius74512923gen_ius
heirs85618563he__irs
henbits12177003henbits
henries102718283henries
jennies143511623jennies
kefirs13396653ke_firs
keirs95313673ke__irs
lechers123313963lechers
lehrs86111133le_h_rs
lenders84419643lenders
lenis56326863len_i_s
lentils73912973lentils
maftirs1236043maftirs
mairs76228303m__airs
mangers103521263mangers
manias84029033man_ias
manics103919933man_ics
manners93417833manners
manors84420883man_ors
mantids103113623mantids
mantis83926033manti_s
mashers124621053mashers
mashies12318253mashies
mealies92821933mealies
meanders1168833meanders
meaners94415243meaners
meanies93620743meanies
medias93620783me_dias
medics114115353me_dics
medius93613283me_dius
medlars10259443medlars
meeters94714543meeters
megahits1445683megahits
megrims1276103megrims
mehndis1343583mehndis
meinies92516073meinies
melders103213913melders
meloids10911453meloids
melters93918313melters
members13258603members
memoir1037213memoir_
menacers12279313menacers
menaces112715523menaces
menads95514383men_ads
menages103615393menages
mender93520793mender_
mendigo11506333mendigo
mendigos12425213mendigos
mending114018683mending
mendings12338303mendings
mends84927693men__ds
menial84223033men_ial
menials94015683menials
meninx1538703men_inx
mensas85115853men_sas
menses84222453men_ses
menshes12310443menshes
mensing103915103mensing
mentees93214503mentees
menthols1347033menthols
mention9314373mention
mentions10312893mentions
mentor8414363mentor_
menudos1034643menudos
menus75822843men__us
mephitis1546113mephitis
mercers114412773mercers
mercies113817563mercies
mergers103813423mergers
merits8320873me_rits
merlins93015813merlins
meshes115019443mesh_es
meshier123410853meshier
meshiest132911033meshiest
meshing134513813meshing
meteors94610013meteors
meters85625833me_ters
methinks1775193methinks
methods1338883methods
meths105320233meth__s
methyls1535453methyls
metiers93312843metiers
metis75025903me_ti_s
metrics11312363metrics
mewlers12288983mewlers
midairs1037203midairs
mincers113714853mincers
minders103720123minders
miners84126633min_ers
minims104514813min_ims
minis75432993min_i_s
minnies93617363minnies
minors85117103min_ors
minters93822473minters
mirs66940573m___irs
mishits122513083mishits
mithers123516733mithers
mohairs1234953mohairs
mohurs1135933m_ohurs
mongers104217273mongers
monies83233163mon_ies
moshers124017843moshers
mothers123717623mothers
munchers15318773munchers
munchies1539253munchies
munis75022003mun_i_s
muntins92715133muntins
mushers124016443mushers
muzhiks2573093muzhiks
mynheers1642113mynheers
noirs55615463__noirs
pencils113011773pencils
penis75129323pen_i_s
penners93414183penners
pennies94218813pennies
pennis84315743penni_s
pensils92811593pensils
rehire95415863re_hire
rehires105016113re_hires
renails74917263renails
renders83821673renders
renigs74314593ren_igs
renins64526453ren_ins
rennins74013413rennins
renters74224813renters
rentiers83311763rentiers
repairs9319973repairs
reships1239863reships
santirs7312963santirs
senders83022353senders
senhor93010813senhor_
senhora10348673senhora
senhoras11278283senhoras
senhores112810993senhores
seniors73413623seniors
sennits73811283sennits
senors63620793sen_ors
sensors73514643sensors
techies12513603techies
tenails73713923tenails
tenders83719723tenders
tenias64720073ten_ias
tenners74014923tenners
tennies73017973tennies
tennis64015303tenni_s
tenors63217753ten_ors
tenours72610073tenours
tenpins9410073tenpins
tensors72712373tensors
tenters73921103tenters
tenuis64213083tenui_s
tethers103815313tethers
unhairs1036373_unhairs
venders113717003venders
vendors113510223vendors
veneers103710293veneers
venins93816703ven_ins
venire93513693ven_ire
venires103012453ven_ires
venters103717733venters
weirs84316493we__irs
wenchers16319213wenchers
wethers135214693wethers
whirs115218093__whirs
xenias133712973xen_ias
zechins21137123zechins
zephyrs2441943zephyrs

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 Filter1786911340270.410435831.7
2DLD Change Limit1340272147.79617191.8
3Display Results2142140.0762815.8
 (SQL Overall)1786912148.28221575.8
 
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.