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 “prods” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

198 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
prods8552355(None) 
plods85719291plods
pods76540151p_ods
poods85124751poods
proas75028801proas
prod76129501prod_
profs105120891profs
progs86624151progs
proms95426411proms
props95726881props
pros65742781pro_s
pross76529401pross
prows106327011prows
rods56442061_rods
apods86316342apods
aprons8316992aprons
aroids75118222aroids
bods76244712_bods
brads85528292brads
broads94515152broads
broods95416382broods
broos75126412broos
bros65635662bro_s
brows105425982brows
clods85320862clods
cods76848102_cods
cords86030622cords
creds85418772creds
crocs95722432crocs
crops96125232crops
cross75124502cross
crowds124910762crowds
crows105727312crows
cruds85815852cruds
droids84712582droids
drops85719502drops
dross65418092dross
ephods1238362ephods
erode64520992erode
erodes74819882erodes
eros45238452ero_s
feods99516852feods
foods95924162foods
fords95328182fords
froes86126692froes
frogs96220772frogs
fronds106412342fronds
frons86124042frons
frows116623102frows
gods65438042_gods
goods75124482goods
grads75625752grads
grids75321392grids
grody103412062grody
grogs76319412grogs
groks105716122groks
gross65421692gross
grots65025852grots
grows95523922grows
hods87239862_hods
hoods95124082hoods
irids66417772irids
irons55324132irons
lords64923502lords
mods77945052_mods
moods85224622moods
nods55838222_nods
ods47546212__ods
ordos65216202ordos
pads76742952p_ads
pagods105310192pagods
pards85634332pards
parodos103011752parodos
parody12410092parody
parols84722612parols
parous84024162parous
peds75835242p_eds
pends85527192pends
peons75327182peons
periods10312242periods
pernods1038482pernods
phons105221142phons
phots105418502phots
pions75826392pions
pious74621272pious
plod76723272plod_
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
pod66351482p_od_
pois66539042p_ois
pols66044562p_ols
poms87037742p_oms
ponds85323402ponds
pons65850602p_ons
pood75934322pood_
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112p_oos
pops86340952p_ops
pores75849032pores
porks115124142porks
porns75527342porns
porous84419482porous
ports75934592ports
pots66452362p_ots
pows95537662p_ows
prams96125512prams
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
prees75937172prees
preops104911942preops
preps96220692preps
press75425952press
preys105717782preys
pride84724732pride
prides94324182prides
pries74339532pries
prigs85219702prigs
prims95425932prims
prions84317782prions
priors83914482priors
priss74623892priss
pro55837262pro__
proa66229962pro_a
probe94320812probe
probes104119452probes
proem94818272proem
proems104711162proems
prof96134662pro_f
prog75729002pro_g
prole74527792prole
proles84627202proles
prom87631702pro_m
promo95620002promo
promos105116422promos
prone75332622prone
prong85218112prong
prongs94314482prongs
proof105221532proof
proofs114511682proofs
prop85932812pro_p
prose75835122prose
proses84733472proses
proso77222412proso
prosos85718552prosos
prost75434102prost
prosy106319252prosy
proud84615482proud
prove104823192prove
proves114322252proves
prow97030382pro_w
prowl105615122prowl
prowls115511082prowls
proxy175011012proxy
prude84615972prude
prudes94215442prudes
psoas75012982psoas
puds75630512p_uds
pyros105718292pyro_s
quods154610222quods
rads56046602_rads
reds56042862_reds
rids56539552_rids
roads66523622_roads
robs65837872_robs
rocs65533662_rocs
rod47953892_rod_
rode55844302_rode
rodes614039082_rodes
roes45954142_roes
roms67038962_roms
roods65125282roods
rots46454092_rots
rows75941752_rows
sarods74918572sarods
scrods94111612scrods
sods54940212_sods
sords64527802sords
tods56141842_tods
trod57627952trod_
trode65322852trode
trogs67022602trogs
trois57226092trois
trots56629942trots
trows88826182trows
troys86418612troys
urds55922432ur_ds
vrows116115262vrows
woods95723032woods
words95425072words
yods86531182_yods

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001981.46636698.5
3Display Results1981980.0464304.3
 (SQL Overall)1786911981.82597912.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.