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

101 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
pueblos113484(None) 
pueblo1035551pueblo_
duellos845762duellos
peplos101211542p_eplos
pumelos11196092pumelos
bubbles104315963bubbles
bumbles134016843bumbles
burbles114916803burbles
cellos84517803_cellos
duello756783duello_
duels65619233due_l_s
dumbos114111083dumb_os
ephebos1444113epheb_os
fuels87117353fue_l_s
fumbles143514413fumbles
gumbos114610873gumb_os
hellos95321683_hellos
helos84928063_he_los
hullos94916293hu_llos
humbles143215803humbles
jellos134714283_jellos
jumbles183013323jumbles
jumbos17379123jumb_os
mueslis935493mueslis
mumbles133014433mumbles
niellos736143niellos
nubbles113412433nubbles
numbles113814273numbles
paellas9411413paellas
peals75235493p_eal_s
pebbles1337573pebbles
pedalos10329703pedalos
pedros9312183p_edros
peels75226423p_eel_s
peles75738083p_e_les
pelfs105016293p_e_lfs
pelon74423213p_e_lon
pelts76128813p_e_lts
pengos94612413p_engos
peplus10138343p_eplus
pepos96620083p_e_pos
pesos77221623p_e_sos
pestos84719083p_estos
phenols1238103phenols
phyllos1535583phyllos
piebalds1344343piebalds
plebes104313623pleb_es
plebs95814583pleb__s
polos76129913p__olos
pomelos11218133pomelos
prebids12399883prebids
prebills1237293prebills
prebless1236823prebless
prebook1557523prebook
prebooks1656303prebooks
preboom1348253preboom
prebuys1444393prebuys
prestos93716083prestos
prunellos1142893prunellos
pseudos1044833pseudos
pubes94423403pu_b_es
pubis94616473pu_b_is
public12238143pu_blic
publics13207143pu_blics
publish1447913pu_blish
pubs85029213pu_b__s
puddles113613823puddles
pules74538813pu__les
pulis74225603pu__lis
pulls74425053pu__lls
pulps95116483pu__lps
puls65437563pu__l_s
pumelo10257113pumelo_
pummelos14223103pummelos
pungles104013713pungles
puntos85915793pu_ntos
pupils10389913pupil_s
pureblood1471943pureblood
purebloods1571723purebloods
purfles122511843purfles
purls74723353pu_rl_s
purples112712833purples
putlog965553pu_tlog
putlogs1065083pu_tlogs
puzzles17318973puzzles
quells15359703que_lls
rubbles113715113rubbles
rubels84112993rubel_s
rubles83921703ru_bles
rumbles114018393rumbles
sublot82315523su_blot
sublots92410913su_blots
telos55424523_te_los
trebles9311443trebles
tumbles113816023tumbles
tupelos936113tupelos
turbos8910783turb_os
umbles103817493_umbles
umbos94613073_umb_os
weblog1234223_weblog
weblogs1334223_weblogs

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271015.93622578.7
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.38827972.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.