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

80 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
jewellers194354(None) 
jewelers1834711jewe_lers
jeweller1844131jeweller_
jewellery2241831jewellery
bevellers14276142bevellers
dwellers12356082_dwellers
jeweler1735052jewe_ler_
jewelled1934342jewelle_d
jewelleries2151562jewelleries
levellers12286052levellers
repellers11278882repellers
resellers9299932resellers
revellers12319512revellers
beetlers1037403be_etlers
bevelers13389463beve_lers
beveller13387693beveller_
bewailers1434233bewailers
bewilders1543813bewilders
bowelless1443833bowelless
cupellers1374863cupellers
duellers9268223_duellers
dweller11297273_dweller_
expellers18104753expellers
feelers103814743fe_e_lers
fellers104117543__fellers
fuellers11277983_fuellers
gruellers1034183gruellers
heelers103815623he_e_lers
heelless11257653he_elless
hellers103619833__hellers
impellers1345103impellers
indwellers1472353indwellers
jeepers16399193je_e_pers
jeerers14328923je_e_rers
jeweled1845333jewe_le_d
jewellike2342243jewellike
jewelling2034833jewelling
jewelries1943033jewelries
jewelry2041993jewe_l_ry
jewels16508613jewe_l__s
jewelweed2341423jewelweed
jewelweeds2451153jewelweeds
keelless12236193ke_elless
kegelers1355163kege_lers
labellers11206553labellers
levelers11259323leve_lers
leveller11317603leveller_
libellers11236033libellers
mewlers12288983mew__lers
modellers1245393modellers
needlers9287423ne_edlers
pedallers1244763pedallers
peelers93615593pe_e_lers
quellers17237533_quellers
ravellers12257163ravellers
recallers1137103recallers
reelers73520273re_e_lers
repealers11278843repealers
repeller103010403repeller_
rerollers9207123rerollers
reseller83412253reseller_
revealers12318243revealers
revelers113414133reve_lers
reveller112912193reveller_
sellers73721323__sellers
sewerless1244303sewerless
shellers112812583_shellers
smellers10329773_smellers
spellers102812763_spellers
sweller103012473_sweller_
swelters113110193_swelters
swillers11299113_swillers
teasellers1043983teasellers
tellers73717603__tellers
trowellers1343663trowellers
welders113313413__welders
welters103516063__welters
willers103517913__willers
yellers103912953__yellers
yodellers1343973yodellers

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 Filter1786911486410.453394461.4
2DLD Change Limit148641807.70319296.5
3Display Results80800.0302666.7
 (SQL Overall)178691808.18621828.9
 
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.