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

101 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
ennoble93563(None) 
ennobled1143831ennobled
ennobler1043541ennobler
ennobles1045111ennobles
enable83318482e_nable
ennoblers1143192ennoblers
enrobe86610792enrob_e
ignoble1043612ignoble
noble74420992__noble
nonnoble1055342nonnoble
anole55330383_ano_le
bannable1278353bannable
bendable131510853bendable
benzole1837133benzo_le
binocle1136493binocle
coble94823173__coble
deniable11312083deniable
eatable91717603eatable
edible969353e_dible
effable15106673effable
enabled102510633e_nabled
enabler9299363e_nabler
enables92813123e_nables
encodable1446273encodable
encode9310443enco_de
encore8314773enco_re
endnote855743endno_te
endorse879203endorse
enfeeble13103223enfeeble
enfold10137613enfo_ld
enforce12237423enforce
engorge945543engorge
enisle63412093e_nisle
enjoyable2143743enjoyable
ennobling1244123ennobling
ennuye973753enn_uye
ennuyee1084153ennuyee
enol45823823e_no_l_
enols54718403e_no_ls
enrobed10279253enrobed
enrober9218623enrober
enrobes92211113enrobes
enrol51014283enro_l_
enroll61110073enro_ll
enrolled967963enrolled
enrollee878343enrollee
enroller867183enroller
enrolls7108093enrolls
enrols61213383enro_ls
ensemble1244973ensemble
ensile62616473e_nsile
ensoul638253ensoul_
ensouled935833ensouled
ensouls736033ensouls
entitle7610293entitle
entoil6912493entoil_
entoiled968283entoiled
entoils7810733entoils
enviable1337853enviable
equable1849253equable
errable9312183errable
etoile6312263e_toile
eyeable1239063eyeable
fencible1545603fencible
finable122213623finable
ignobly1342873ignobly
indole74516053indo_le
insole63515863inso_le
lendable11169463lendable
linable92214343linable
mendable131510583mendable
minable112315073minable
monocle1139663monocle
nibble103713283_nibble
nimble103412943_nimble
nobble103814313_nobble
nobler83713453__nobler
nobles83319723__nobles
nobly105314403__nobly
noodle73212543_noodle
nubble103813713_nubble
ownable1237283ownable
pinocle1138143pinocle
pinole83218783pino_le
rendible11128353rendible
rentable101716333rentable
roble75223023__roble
sendable111612043sendable
sensible1037853sensible
snoozle16305913snoozle
tannable1039383tannable
tenable93214493tenable
tensible1037243tensible
tunable92511313tunable
unable83819223_unable
undoable1139053undoable
undouble1145443undouble
unrobe82611673unrob_e
vendable14159693vendable
vendible14156473vendible
winnable13156983winnable

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.406440125.6
2DLD Change Limit1340271015.89022755.0
3Display Results1011010.0303366.7
 (SQL Overall)1786911016.32628247.1
 
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.