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

99 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
jeweller184413(None) 
jeweler1735051jewe_ler
jewelled1934341jewelled
jewellers1943541jewellers
jewellery2241831jewellery
beveller13387692beveller
dweller11297272_dweller
jeweled1845332jewe_led
jewelers1834712jewe_lers
leveller11317602leveller
repeller103010402repeller
reseller83412252reseller
reveller112912192reveller
sweller103012472_sweller
beetler938043be_etler
bejewelled2351493bejewelled
beveler124010693beve_ler
bevelled14327823bevelled
bevellers14276143bevellers
bewailer1334863bewailer
bewilder1434133bewilder
bowelled1446183bowelled
crueller1056453crueller
cupeller1256103cupeller
dowelled1356343dowelled
dueller8329833_dueller
dwelled12337593_dwelled
dwellers12356083_dwellers
eelier64216463_e_elier
eviller1056673_eviller
expeller17105793expeller
feebler1235823fe_ebler
feeler93215173fe_e_ler
feller94419553__feller
fueller10279963_fueller
grueller935333grueller
heeler93917313he_e_ler
heller93322513__heller
impeller1236083impeller
indweller1393013indweller
jeerer13389933je_e_rer
jelled144916063j__elled
jewel156711703jewe_l__
jeweling1935483jeweling
jewelleries2151563jewelleries
jewellike2342243jewellike
jewelling2034833jewelling
jewelries1943033jewelries
jewelry2041993jewe_lry
jewels16508613jewe_l_s
jewelweed2341423jewelweed
jowlier17327563jow_lier
kegeler1245493kege_ler
labeller10248073labeller
leveler10399903leve_ler
levelled12327453levelled
levellers12286053levellers
libeller10297433libeller
mewler113510233mew__ler
modeller1136613modeller
needler8388893ne_edler
pedaller1136093pedaller
peeler83517383pe_e_ler
queller16289293_queller
raveller11339263raveller
rebelled113110333rebelled
recaller1039323recaller
reeler63822573re_e_ler
refelled122810173refelled
repealer103210703repealer
repelled113111593repelled
repellers11278883repellers
reroller8258753reroller
resellers9299933resellers
revealer113110073revealer
reveler104116343reve_ler
revelled123712743revelled
revellers12319513revellers
rewelded1335893rewelded
rowelled1236633rowelled
seller63824603__seller
sheller103515893_sheller
smeller94212793_smeller
sneller73512853_sneller
speller95415153_speller
swelled113211703_swelled
swelter103711173_swelter
swiller103211663_swiller
teaseller945223teaseller
teller63519823__teller
towelled1236353towelled
troweller1244563troweller
upwelled1434663upwelled
welder102914413__welder
welled103820213__welled
welter93417383__welter
willer94021063__willer
yeller94214513__yeller
yodeller1244853yodeller

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 Filter1786911461620.420425454.8
2DLD Change Limit146162996.53022383.2
3Display Results99990.0501980.0
 (SQL Overall)178691997.00025527.3
 
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.