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

103 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
labellers1120655(None) 
labelers10249411labe_lers
labeller10248071labeller_
libellers11236031libellers
gabelles11278932gabelle_s
labeler92310182labe_ler_
labelled11278292labelle_d
levellers12286042levellers
libelers10238622libe_lers
libellees11274982libellees
libeller10297432libeller_
ravellers12257162ravellers
abeles84719393_abe_le_s
abetters1057173_abetters
ateliers837883_ateliers
babblers113510353bab_blers
ballers94421013__ballers
beliers94617383__beliers
belles85325993__belle_s
belters93819413__belters
bevellers14276113bevellers
billers94720823__billers
caballero1342883caballero
caballeros1442033caballeros
cablers114416713cab__lers
cadelles1139953cadelle_s
callers94221963ca__llers
cameleers1345093cameleers
canallers1137213canallers
cancellers1445363cancellers
carollers1137703carollers
cavillers1435603cavillers
cupellers1374863cupellers
dabblers13379363dab_blers
duellers9268223_duellers
dwellers12356083_dwellers
enamellers1242763enamellers
expellers18104743expellers
fablers124812613fab__lers
fallers103917993fa__llers
fellers104117543__fellers
fuellers11277983_fuellers
gabblers134110083gab_blers
gabelle10259213gabelle__
gabelled12317583gabelle_d
gaseliers1044923gaseliers
gazelles18266563gazelle_s
glabellar1243243glabellar_
gruellers1034183gruellers
hellers103619833__hellers
impellers1345103impellers
jewellers1943533jewellers
labeled102510563labe_le_d
labella988943labell__a
labellate11126923labellate
labelling1238073labelling
labelloid1243663labelloid
labellum1274273labell_um
labels84515683labe_l__s
laborers10208383lab_orers
labourers1144713labourers
laceless10239853lace_less
ladlers84613563la__dlers
lamellar1096483lamellar_
lamellas1098153lamell_as
lamenters1137683lamenters
landlers94312833la_ndlers
lapelled11227083lapelle_d
lateeners945563lateeners
lavaliers1254283lavaliers
laveers10329363lave__ers
lavenders1334753lavenders
levelers11259323leve_lers
leveller11317593leveller_
libelees10227213libe_lees
libeler9219003libe_ler_
libelled11317213libelle_d
libellee10227733libelle_e
libellous1143633libellous
lollers72713793l__ollers
lullers73213353l__ullers
marcellers1443833marcellers
modellers1245393modellers
nacelles1048393nacelle_s
quellers17237533_quellers
rabblers123810853rab_blers
ravelers113310863rave_lers
raveller11339263raveller_
repellers11278873repellers
resellers9299903resellers
revellers12319503revellers
sellers73721303__sellers
shellers112812563_shellers
smellers10329753_smellers
spellers102812743_spellers
tableless1145023tableless
teasellers1043953teasellers
tellers73717583__tellers
travellers1364663travellers
umbellets1343343umbellets
wabblers15398993wab_blers
yellers103912953__yellers
yodellers1343973yodellers

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411036.45323034.4
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.66926794.3
 
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.