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

132 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
pueblo103555(None) 
pueblos1134841pueblos
duello756782duello
pumelo10257112pumelo
bubble94016593bubble
bubbly124110353bubbly
bubo85621913bu_b_o
bumble124216893bumble
burble104617703burble
burbly134311153burbly
cello74919583_cello
duel56729703due_l_
duelli767003duelli
duellos845763duellos
duels65619233due_ls
dumbly14399603dumbly
dumbo105614063dumb_o
feeble1138253feeble
feebly1436653feebly
fuel76824733fue_l_
fuels87117353fue_ls
fumble133214263fumble
gumbo104413583gumb_o
hello86522983_hello
helo75332853_he_lo
hubbly16478413hubbly
hullo84417453hu_llo
humble133615053humble
humbly164010523humbly
jello126716273_jello
jumble174012653jumble
jumbo164311073jumb_o
muesli835183muesli
mumble123614343mumble
mumbly15319463mumbly
niello636603niello
nubble103813713nubble
nubbly13369673nubbly
numbly134410663numbly
paella8410913paella
peal68648103p_eal_
peals75235493p_eals
pebble1238003pebble
pebbly1545083pebbly
pedalo93811153pedalo
pedro8313153p_edro
peel65535613p_eel_
peels75226423p_eels
pele65539553p_e_le
pelf97031453p_e_lf
pelon74423213p_e_lon
pelt67651083p_e_lt
pengo84317593p_engo
pepla9312863p_epla
peplos101211543p_eplos
pepo87622153p_e_po
peso66925823p_e_so
pesto75723723p_esto
petto76021043p_etto
phenol1149253phenol
phyllo1435873phyllo
piebald1245503piebald
pleb86123813pleb__
plebe95014873pleb_e
plebes104313623plebes
plebs95814583pleb_s
polo66236633p__olo
pomelo10238663pomelo
prebid113512843prebid
prebill1138803prebill
prebook1557523prebook
preboom1348253preboom
prebuy1357423prebuy
prepueblo1551553prepueblo
presto84216203presto
prunello1043433prunello
pseudo934713pseudo
pub76037693pu_b__
pubes94423403pu_bes
pubic114513723pu_bic
pubis94616473pu_bis
public12238143pu_blic
pubs85029213pu_b_s
puddle103914153puddle
puddly13438133puddly
puerile9310093puerile
pul56138063pu__l_
pula65129373pu__la
pule65040953pu__le
puli65527623pu__li
pull64731663pu__ll
pulls74425053pu_lls
pulp84825353pu__lp
puls65437563pu__ls
pumelos11196093pumelos
pummelo13284233pummelo
pungle94413573pungle
punily11311773punily
punto75121323pu_nto
pupal97616873pupal_
pupil94712983pupil_
pupils10389913pupils
pureblood1471943pureblood
purely114013633purely
purfle112511183purfle
purl65631423pu_rl_
purls74723353pu_rls
purple102712683purple
purply13369053purply
pussly11407373pussly
putlog965553pu_tlog
putto75617663pu_tto
puzzle16318603puzzle
quell144311433que_ll
quells15359703quells
rubble104315673rubble
rubbly133710613rubbly
rubel75416833rubel_
rubels84112993rubels
ruble74521253ru_ble
rumble103718813rumble
rumbly134412163rumbly
suable83920553suable
suably112814533suably
sublot82315523su_blot
treble8311663treble
trebly1138973trebly
tumble103215643tumble
tupelo836483tupelo
turbo71015043turb_o
umbo85516663_umb_o
weblog1234223_weblog

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 Filter1786911127160.373479064.3
2DLD Change Limit1127161327.94014196.0
3Display Results1321320.0462869.6
 (SQL Overall)1786911328.35921377.1
 
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.