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

88 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
pedallers124476(None) 
pedalers11239391peda_lers
pedalfers1542901pedalfers
pedaliers1245181pedaliers
pedaller1136091pedaller_
pearlers1039032pe_arlers
pedaler103410692peda_ler_
pedalfer1443272pedalfer_
pedalier1137602pedalier_
pedalled1246922pedalle_d
peddlers12298532ped_dlers
pedlers103013272ped__lers
recallers1137102recallers
ballers94421013__ballers
bevellers14276113bevellers
bewailers1434233bewailers
callers94221963__callers
canallers1137213canallers
dalles74222063__dalle_s
dalliers93610613__dalliers
dealers84118613de_a_lers
desalters1037673desalters
detailers10257253detailers
diallers957773_diallers
enablers10196913_enablers
exalters1536653_exalters
fallers103917993__fallers
fellers104117543fe__llers
healers104319463he_a_lers
hellers103619833he__llers
idealless1042953idealless
jewellers1943533jewellers
levellers12286043levellers
mealless10288363me_alless
medalled1246893medalle_d
meddlers12318203med_dlers
modellers1245393modellers
paddlers12329153pad_dlers
pallets93919303p__allets
pallors9314363p__allors
palmers113513623p__almers
palters94021683p__alters
parallels1145263parallels
peachers153213843pe_achers
peakless14236683pe_akless
pearler9310373pe_arler_
pedaled113711883peda_le_d
pedalling1346663pedalling
pedalos10329703peda_l_os
pedals94316033peda_l__s
peddler113210493ped_dler_
peddlery15224003ped_dlery
peddles112913703ped_dle_s
pedicles1338683pedicle_s
pedlars103210213ped__lars
pedler93614613ped__ler_
pedlery13297073ped__lery
peelers93615593pe__elers
pellets94014783pe__llets
pelters93720313pe__lters
pencilers1345643pencilers
pencillers1443823pencillers
peoplers1237153pe_oplers
petalled1138693petalle_d
piddlers12359593pid_dlers
pollers93420023p__ollers
prealters1147773prealters
prevailers15123833prevailers
psalters10227713p_salters
puddlers12298683pud_dlers
pullers93618483p__ullers
realters83614043re_alters
recaller1039323recaller_
regalers94311133rega_lers
repellers11278873repellers
rerollers9207123rerollers
resellers9299903resellers
retailers9258773retailers
revellers12319503revellers
sealers74323553se_a_lers
sellers73721313se__llers
spallers102910733_spallers
spellers102812753spe__llers
squallers1834683squallers
tellers73717593te__llers
vealers103214293ve_a_lers
yellers103912953ye__llers
yodellers1343973yodellers

Search took 10 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.190940478.9
2DLD Change Limit148641889.04616431.7
3Display Results88880.0302933.3
 (SQL Overall)178691889.26619284.6
 
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.