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 “menorah” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
menorah124793(None) 
menorahs1346541menorahs
begorah1355592begorah
senora63216162senora_
senoras72714952senoras
anorak1038923_anorak
begorrah1441823begorrah
cenotaph1542633cenotaph
centra84113883centra_
central93114473central
engram9310653_engram
enorm74415643_enor_m
enough1045763_enough
entrap8710563_entrap
enwrap1185213_enwrap
fedora1038593fedora_
fedoras1137923fedoras
femora1149583femora_
femoral1238723femoral
genera71211713genera_
general81010943general
genoa64315823geno_a_
genoas74013623geno_as
genogram1246733genogram
gerah9315303ge__rah
hoorah124411113_hoorah
horah117922053__horah
manor78023933manor__
manorial10311083manorial
manors84420883manor_s
mantra84116093mantra_
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
mayoral1237693mayoral
megara9310093megara_
memorial1249523memorial
memory1338803memor_y
menad85918983men__ad
menarche1545813menarche
menial84223033men_ial
meno66031363meno___
menorrhea1453503menorrhea
mensa75318673men_sa_
mensae84114053men_sae
mensal84615663men_sal
mensas85115863men_sas
mensch13387103men_sch
mensh105413563men__sh
mensural1046233mensural
menta74424423men_ta_
mental84521603men_tal
mentor8414363mentor__
mentored1138003mentored
mentors9314993mentor_s
merch125417963me__rch
mesarch1445533mesarch
messiah1246793messiah
metopae1147743metopae
mezuzah2041973mezuzah
mineral9312743mineral
minor74920063minor__
minorca1145223minorca
minorcas1245973minorcas
minored10310103minored
minors85117103minor_s
monarch1445953monarch
moneran9311113moneran
monocrat12410783monocrat
monogram1379183monogram
monograph1748643monograph
monorail1059773monorail
moolah11409193m_oolah
mora66641273m__ora_
morae75831193m__orae
moral75533433m__oral
moras76438783m__oras
moray105423793m__oray
morph121712513m__orph
mynah13569563myn__ah
nonoral7313603nonoral
north86018273__north
peroral9314793peroral
remora8414593remora_
remoras9314073remoras
renogram1147953renogram
senhora10348673senhora_
senhoras11278283senhoras
senor53822803senor__
senores73218113senores
senors63620793senor_s
tenor53620253tenor__
tenors63217753tenor_s
torah87125273__torah
venogram1476593venogram
ventral103612173ventral

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 Limit134027967.48617903.7
3Display Results96960.0303200.0
 (SQL Overall)178691967.92222556.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.