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

111 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
perduring133601(None) 
perjuring1944921perjuring
enduring10310012_enduring
everduring1543292everduring
perfuming1784052perfuming
perfusing1565632perfusing
permuting1446552permuting
perturbing1543562perturbing
perusing11811062per_using
precuring1439422precuring
bordering1338833bordering
censuring1237603censuring
coenduring1444233coenduring
deducing1336423de_ducing
detouring1136973detouring
devouring1435953devouring
during84419403___during
educing1137683_e_ducing
enduing9249723_endu_ing
ensuring9310173_ensuring
enuring8813883_e_nuring
erring73816483_er__ring
featuring1337323featuring
ferruling13134423ferruling
feruling1258873fer_uling
gendering12249753gendering
gesturing1136653gesturing
herding122915123herd__ing
herring113615883her__ring
lecturing1237303lecturing
measuring1236123measuring
murdering1357133murdering
murmuring1443633murmuring
nurturing1045013nurturing
ordering1039353_ordering
overcuring16108763overcuring
overdaring1539503overdaring
overturing1499413overturing
pandering133211963pandering
pardoning1338763pardoning
parring103222063par__ring
pasturing1238433pasturing
pedaling122412133pe_daling
peddling13217973pe_ddling
pedicuring1643243pedicuring
peering103520353pe__ering
peltering122011673peltering
pending114119773pend__ing
peppering1337083peppering
perching163711633per_ching
percussing1545223percussing
perdure10379623perdur__e
perdured12287403perdur_ed
perdures11289683perdur_es
peregrin1146993peregrin_
peregrine1247043peregrine
peregrins1246963peregrins
performing1844943performing
periling11316863per_iling
perilling12410003perilling
perishing1539533perishing
perjuries1846493perjuries
perking143716463per__king
perming123416093per__ming
perspiring1544853perspiring
persuading1454503persuading
pervading1636303pervading
perverting1646623perverting
pestering122315663pestering
petering112516813pe_tering
picturing1436033picturing
pleasuring1343503pleasuring
pondering132411333pondering
portering122012303portering
posturing1238993posturing
pouring103115863p__ouring
powdering16246503powdering
prebuying1734303prebuying
predating13514653predating
predrying1645343predrying
prefiring1559073prefiring
prehiring1548383prehiring
preluding1337053preluding
preordering15124303preordering
preparing14311643preparing
pressuring1346513pressuring
presuming1437663presuming
prevuing1457253prevu_ing
prewiring1547893prewiring
procuring1437993procuring
producing1556143producing
pruning10311733p_r_uning
purpurin1254583purpurin_
purpurins1364463purpurins
purring104515823pur__ring
pursuing1146233pursu_ing
reducing12310203re_ducing
rendering112213183rendering
reordering1266213reordering
repouring12310073repouring
rerouting10311873rerouting
securing11310413se_curing
seducing1236503se_ducing
teddering12256303teddering
tendering112210813tendering
tenuring938863te_nuring
texturing1735223texturing
torturing1036253torturing
veluring1237563ve_luring
venturing1337553venturing
vesturing1337203vesturing

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411117.48319863.8
3Display Results1111110.0631761.9
 (SQL Overall)1786911117.96922423.3
 
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.