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

142 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
leveller1131760(None) 
beveller13387691beveller
leveler10399901leve_ler
levelled12327451levelled
levellers12286051levellers
reveller112912191reveller
beveler124010692beve_ler
bevelled14327822bevelled
bevellers14276142bevellers
eviller1056672_eviller
jeweller1844132jeweller
labeller10248072labeller
leveled114010382leve_led
levelers11259322leve_lers
levelly1335852levell_y
libeller10297432libeller
livelier1136872livelier
lovelier1136432lovelier
raveller11339262raveller
repeller103010402repeller
reseller83412252reseller
revealer113110072revealer
reveler104116342reve_ler
revelled123712742revelled
revellers12319512revellers
beetler938043be_etler
beveled133811133beve_led
bevelers13389463beve_lers
caviller1337063caviller
cleverer1334563cleve_rer
crueller1056453crueller
cupeller1256103cupeller
develed123611933deve_led
developer15134243developer
devilled1336743devilled
driveller1353853driveller
dueller8329833_dueller
dweller11297273_dweller
eelier64216463_e_elier
evener91010623_eve_ner
eviler94811893_ev_iler
evolver13275803_evolver
expeller17105793expeller
feebler1235823fe_ebler
feeler93215173fe_e_ler
feller94419553__feller
fueller10279963_fueller
gavelled13387363gavelled
groveller1354233groveller
grueller935333grueller
heeler93917313he_e_ler
heller93322513__heller
hovelled15146843hovelled
impeller1236083impeller
jeweler1735053jewe_ler
jewelled1934343jewelled
jewellers1943543jewellers
jewellery2241833jewellery
kegeler1245493kege_ler
kvelled15276063_kvelled
labeler92310183labe_ler
labelled11278293labelled
labellers11206553labellers
lamellar1096493lamellar
lapelled11227083lapelled
lavalier1146043lavalier
laveer94110423lave__er
lavender1235143lavender
leerier73111503le_erier
levanter1145303levanter
levee84023813leve__e_
leveed104111373leve__ed
levees93714523leve__es
level84116553leve_l__
leveling122910433leveling
levelling13206973levelling
levelness1245453levelness
levels94113283leve_l_s
lever85125163lev___er
levered114212303leve_red
leveret103014003leve_ret
levier94013873lev__ier
libeler9219003libe_ler
libelled11317213libelled
libellee10227733libellee
libellers11236033libellers
likelier1235283likelier
livener10278943live_ner
loller63315283l__oller
lonelier838003lonelier
lovelies1139893lovelies
luller63415483l__uller
modeller1136613modeller
needler8388893ne_edler
novelle1058233novelle_
pedaller1136093pedaller
peeler83517383pe_e_ler
queller16289293_queller
raveler104212463rave_ler
ravelled12419783ravelled
ravellers12257163ravellers
rebelled113110333rebelled
recaller1039323recaller
reeler63822573re_e_ler
refelled122810173refelled
repealer103210703repealer
repelled113111593repelled
repellers11278883repellers
reroller8258753reroller
resellers9299933resellers
revealed123211213revealed
revealers12318243revealers
reveille1145333reveille_
reveilles1245203reveilles
reveled113917753reve_led
revelers113414133reve_lers
revenger1237303revenger
revenuer1136893revenuer
reverer103815833reve_rer
reverser113010483reverser
reverter114812873reverter
reviler104314973rev_iler
revolter11279363revolter
revolver14287713revolver
seller63824603__seller
severer103511563seve_rer
sheller103515893_sheller
shoveller15174543shoveller
smeller94212793_smeller
sneller73512853_sneller
sniveller1253703sniveller
speller95415153_speller
svelter10359673_svelter
sweller103012473_sweller
teaseller945223teaseller
teller63519823__teller
traveller1266603traveller
unlevelled1443033unlevelled
vealer94016543__vealer
veiler93814353__veiler
yeller94214513__yeller
yodeller1244853yodeller

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.423422437.4
2DLD Change Limit1461621427.54619369.5
3Display Results1421420.0632254.0
 (SQL Overall)1786911428.03222247.4
 
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.