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

119 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
prangs9481623(None) 
orangs74116031orangs
pangs84628671p_angs
parangs104314381parangs
prang84820321prang_
pranks124814721pranks
prongs94314481prongs
sprangs104610051sprangs
wrangs104611911wrangs
bangs85627782_bangs
bhangs12449662bhangs
brags85625102bra_gs
brands95118942brands
branks124817382branks
brans75437432bran_s
brants85723052brants
brings94618432brings
changs125215372changs
clangs95113612clangs
crags85622572cra_gs
cranes84330752cranes
cranks125015312cranks
dangs75623212_dangs
drags75521112dra_gs
fangs96224082_fangs
frags96322172fra_gs
francs114112192francs
franks134912732franks
gangs76222582_gangs
grands84218242grands
grange83716202grange
granges93516522granges
grans64832542gran_s
grants73722472grants
hangs95726732_hangs
kiangs11378362kiangs
liangs74410592liangs
orang65119942orang_
orange74016322orange
oranges84215332oranges
orangy105111232orangy
ourangs8318502ourangs
panes76148692p_anes
pang75336302p_ang_
panga85323542p_anga
pangas99921112p_angas
pans65855732p_an_s
pants76536922p_ants
parang93715512parang_
parings104219222parings
peags86122842pea_gs
peans75437642pean_s
penangs10268372penangs
pianos84315932pianos
pians75126962pian_s
pinangs10267792pinangs
pings85830882p_ings
piranas9912612piranas
planes85028082planes
planks124116752planks
plans75731272plan_s
plants84921802plants
pongs85526342p_ongs
praams10459642praams
prahus11458242prahus
prajnas1635462prajnas
prams96125512pra_ms
prance104318572prance
prances113618782prances
pranged114512552pranged
prank115019452pran_k
praos74923562pra_os
prases84429022prases
prates84633162prates
prats76333392pra_ts
praus74621752pra_us
prawns11509022prawns
praxes156215182praxes
praxis154012252praxis
prays105022432pra_ys
prigs85219702pr_igs
prinks124315382prinks
prints84320102prints
probangs13256212probangs
progs86624152pr_ogs
prong85218112prong_
prunes83419062prunes
prunus8399362prunus
pungs85422222p_ungs
puranas9712652puranas
pyrans11411062pyran_s
raggs75216472_raggs
rags55448372_ra_gs
rands65930452_rands
rang56939172_rang_
range64728422_range
ranges73826932_ranges
rangy95320392_rangy
ranis55235842_ranis
ranks95225732_ranks
rants55935342_rants
rings65029172_rings
rungs611819402_rungs
slangs75615342slangs
sprags95715822spra_gs
sprang95713522sprang_
springs104415922springs
stangs75018172stangs
tangs65028362_tangs
tranks104017762tranks
tranqs155210312tranqs
trans54933042tran_s
twangs10358102twangs
vangs96319602_vangs
whangs13439722whangs
wrang94716112wrang_
wrings104012972wrings
wrongs10338932wrongs
yangs95618702_yangs

Search took 5 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.340525561.8
2DLD Change Limit825511193.84621464.1
3Display Results1191190.0462587.0
 (SQL Overall)1786911194.23242223.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.