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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
permuting144655(None) 
perduring1336012perduring
perfuming1784052perfuming
perfusing1565632perfusing
perjuring1944922perjuring
permeating1539922permeating
perming123416092perm__ing
permitting1546302permitting
perusing11811062per_using
rerouting10311872rerouting
aerating92821003aer_ating
bemusing1336613be_musing
berating113220763ber_ating
berming123614833berm__ing
besmutting1553353besmutting
bruting102612993_br_uting
commuting16288443commuting
cremating14312203cremating
debuting12268633de_buting
demoting12311423de_moting
deputing12238793de_puting
derating103222283der_ating
deratting1139513deratting
eluting84115293_e_luting
emoting10313563_e_moting
erecting112415063_erecting
eructing112110173_eructing
erupting11218443_erupting
fermenting1646823fermenting
ferreting13127703ferreting
ferruling13134423ferruling
feruling1258873fer_uling
gemmating1576443gemmating
grouting103410793_grouting
helmeting1545503helmeting
meriting11314693mer_iting
murmuring1443633murmuring
muting93921523___muting
operating12313723oper_ating
parenting12611583parenting
pargeting1338283pargeting
parqueting2243633parqueting
parroting1239153parroting
parting103527383par__ting
pelleting1237953pelleting
pelting102917273pe__lting
perching163711633per_ching
percussing1545223percussing
perfecting1847513perfecting
periling11316863per_iling
perilling12410003perilling
perishing1539533perishing
perking143716463per__king
permute1138793permut__e
permuted1336713permut_ed
permutes1238713permut_es
perorating13313133perorating
persecuting1643833persecuting
persisting1346653persisting
persuading1454503persuading
perturbing1543563perturbing
pervading1636303pervading
perverting1646623perverting
petting103720953pe__tting
pirating11314513pir_ating
polluting1235703polluting
porting103021783por__ting
pouting103519943p__outing
prating103424453p_r_ating
preacting142412533preacting
prebuying1734303prebuying
precuring1439423precuring
precutting1546423precutting
predating13514653predating
preempting1745393preempting
preluding1337053preluding
premising14412413premising
premixing2157803premixing
presuming1437663presuming
prevuing1457253prevu_ing
printing113216083p_rinting
promoting1439923promoting
prompting1637203prompting
pruning10311733p_r_uning
pursuing1146233pursu_ing
refuting121911903re_futing
remating112322423re_mating
reputing112412603re_puting
rerenting102617663rerenting
routing83821093__routing
seriating10916403seriating
serrating10513213serrating
sprouting1236943sprouting
tempting1357343te_mpting
terming104016003term__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.420425454.8
2DLD Change Limit148641956.83021763.0
3Display Results95950.0303166.7
 (SQL Overall)178691957.28024545.5
 
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.