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

152 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
deperming153711(None) 
degerming1435751degerming
decerning1337292decerning
deeming113913122de_e_ming
deferring1436142deferring
deforming1636702deforming
demerging1436642demerging
departing1349512departing
depending14208782depending
depluming1544712depluming
deporting1369592deporting
deserting11713142deserting
deserving1497902deserving
deterging1237852deterging
determine1249032determine
deterring1138622deterring
deworming1635042deworming
perming123416092__perming
reperking1638702reperking
adeeming1254793ade_e_ming
aspersing1237603aspersing
berming123614833__berming
beseeming1435143beseeming
beworming1734553beworming
capering132414963caper_ing
deaerating12311563deaerating
deairing10311893deair_ing
debarking1735383debarking
debarring1335723debarring
debeaking1735923debeaking
debearding1543733debearding
deceasing1338403deceasing
deceiving1635733deceiving
decreeing1335523decreeing
decrying15237413de_crying
decurving1634723decurving
deeding103315123de_e_ding
deepening1335613deepening
defaming15238463de_faming
defeating142311973defeating
defecting162510223defecting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferment151210303deferment
defoaming1645653defoaming
deforcing1636063deforcing
degumming1643133degumming
dehorning1455243dehorning
dehorting1447213dehorting
dejecting20217793dejecting
dekeing13358353deke__ing
deleading1237773deleading
deleaving1436263deleaving
deleing93313953dele__ing
deleting103314423dele_ting
deliming12310373de_liming
demarking1736773demarking
demeaning1337243demeaning
dementing13311043dementing
demeriting1448683demeriting
demurring1335253demurring
depeopling1642643depeopling
deperm1139363deperm___
depermed1436453deperm_ed
deperms1236603deperm__s
depicting1537813depicting
deplaning1338053deplaning
depleting1378193depleting
deploring1337853deploring
deploying1636153deploying
deponing121211213dep_oning
deposing12129773dep_osing
depraving1635973depraving
depressing1448093depressing
depriving1636403depriving
depurating1438643depurating
deputing12238793dep_uting
descrying1635103descrying
deservings1593663deservings
desexing1736293dese_xing
desiring10312143desir_ing
desorbing1346363desorbing
detecting13259983detecting
determent121312903determent
determined1455823determined
determiner1345483determiner
determines1358433determines
determining1545293determining
detesting112610323detesting
deveining1436393deveining
develing133212733deve_ling
devesting14249903devesting
diapering1339033diaper_ing
disarming1338803disarming
dispersing1449303dispersing
diverging15226693diverging
diverting142410333diverting
dowering132510613dower_ing
dreaming124011063d_reaming
emerging1237893_emerging
everting122213133_everting
exerting162211153_exerting
experting1938053experting
fevering152510083fever_ing
jeering153513043je_er_ing
leering83417643le_er_ing
levering122212503lever_ing
metering112915633meter_ing
nevermind1543303nevermind
papering132213313paper_ing
peering103520353pe_er_ing
peppering1337083pepper_ing
peppermint1554253peppermint
perking143716463__perking
petering112516813peter_ing
rearming111413613re_arming
redeeming1337363redeeming
referring1338033referring
reforming1538563reforming
rehemming1734743rehemming
remerging1358323remerging
reparking1638923reparking
repealing122513543repealing
repeating122618983repeating
repegging1435593repegging
repelling122312753repelling
repenting122316553repenting
reporting12513903reporting
reserving131110643reserving
reteaming122110443reteaming
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
reverting132315133reverting
rewarming15147383rewarming
rezeroing1935933rezeroing
secerning1246203secerning
seeming103216263se_e_ming
severing122013853sever_ing
sewering122411093sewer_ing
speering113116323speer_ing
spermine12311433_spermine
supering11317683super_ing
supermind1449043supermind
supermini1348953supermini
tapering112112503taper_ing
teeming103513093te_e_ming
tempering1438733temper_ing
tepefying1843233tepefying
terming104016003__terming
veering113213683ve_er_ing

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 Limit1486411527.39020113.8
3Display Results1521520.0801900.0
 (SQL Overall)1786911527.89322639.2
 
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.