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

114 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
prunes8341906(None) 
prudes94215441prudes
prune75119631prune_
pruned93413111pruned
pruner83413451pruner
pruners93710721pruners
prunus8399361prunus
runes55530221_runes
arenes64928392arenes
brines85028852brines
brumes106417072brumes
brunet84419292brunet
brunets9419552brunets
brunts85215452brunts
brutes86118682brutes
bruxes154811022bruxes
cranes84330752cranes
crones84729242crones
cruces105117542cruces
crudes96218622crudes
cruses88127712cruses
cruxes154911562cruxes
drones75023432drones
drunks11427512drunks
drupes94912652drupes
druses75517252druses
dunes65332172_dunes
ernes55224812er_nes
grues65721962gru_es
grumes94415552grumes
grunges93310402grunges
grunts75511852grunts
irones64724012irones
lunes55337772_lunes
panes76148692p_anes
pannes85522852pannes
parures9512692parures
pauses84621472pauses
penes75839222p_enes
peones83821042peones
perukes133210112perukes
peruses94018162peruses
phones114121212phones
pines76048862p_ines
planes85028082planes
plumes104318132plumes
plunges104011612plunges
plunks124711162plunks
pluses83618072pluses
pones74547042p_ones
pounces114113892pounces
pounds93714382pounds
prances113618772prances
prangs94816232prangs
pranks124814722pranks
prases84429022prases
prates84633162prates
praxes156215182praxes
preens85020112preens
prees75937172pr_ees
prexes154915942prexes
prezes173614692prezes
prices104524542prices
prides94324182prides
pries74339532pr_ies
primes104225262primes
princes113015142princes
prinks124315382prinks
prints84320102prints
prises84133172prises
prizes173819812prizes
probes104119452probes
proles84627202proles
prone75332622prone_
prongs94314482prongs
proses84733472proses
proves114322252proves
prude84615972prude_
prunuses1035122prunuses
pubes94423402p_ubes
puces94924632p_uces
pukes114523022p_ukes
pules74538812p_ules
punas74826752p_unas
pungs85422222p_ungs
punks114822682p_unks
puns66641482p_un_s
punts75828002p_unts
purees84721682purees
purges94421762purges
purines94420762purines
purses84826372purses
puses75532202p_uses
pyrenes123511222pyrenes
pyrones123113302pyrones
rubes74928412_rubes
rues46044482_ru_es
rules55234252_rules
rune45236292_rune_
rungs611819402_rungs
runs46438072_run_s
runts55927632_runts
ruses56136582_ruses
spruces113810502spruces
sprues84515762spru_es
trines64132562trines
triunes74311382triunes
trones65629282trones
truces84916332truces
trues54925322tru_es
trunks10429752trunks
tunes55332192_tunes
urines64724122urines
uruses63616502uruses

Search took 4 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 Filter178691825510.1401276364.3
2DLD Change Limit825511142.93628116.8
3Display Results1141140.0333454.5
 (SQL Overall)1786911143.10957475.4
 
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.