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

68 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
perfuming178405(None) 
perfusing1565631perfusing
perduring1336012perduring
performing1844942performing
perjuring1944922perjuring
perming123416092per__ming
permuting1446552permuting
perusing11811062per_using
presuming1437662presuming
berhyming2042713berhyming
beriming13310463ber_iming
berming123614833ber__ming
defaming15238463de_faming
defusing13227933de_fusing
defuzing22195253de_fuzing
depluming1544713depluming
effusing1534263_effusing
exhuming2143303_exhuming
ferruling13134423ferruling
feruling1258873fer_uling
fuming124013293___fuming
kerfing15307533kerf__ing
perching163711633per_ching
percussing1545223percussing
perfecting1847513perfecting
perfume1446503perfum__e
perfumed1654533perfum_ed
perfumer1574553perfum_er
perfumers1683713perfumers
perfumery1972373perfumery
perfumes1555893perfum_es
perfumy1763933perfum__y
perfusion14105883perfusion
perfusions1595333perfusions
perfusive1744343perfusive
periling11316863per_iling
perilling12410003perilling
perishing1539533perishing
perking143716463per__king
persuading1454503persuading
perturbing1543563perturbing
pervading1636303pervading
pluming123412043p__luming
prearming14139223prearming
prebuying1734303prebuying
precuring1439423precuring
prefacing17118743prefacing
prefading16149033prefading
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
preforming1846233preforming
prefunding1745233prefunding
preluding1337053preluding
prevuing1457253prevu_ing
priming123417373p_r_iming
primming15268173p_rimming
pruning10311733p_r_uning
purfling1467763purf_ling
pursuing1146233pursu_ing
reframing1538623reframing
refuging13218423re_fuging
refusing122310873re_fusing
refuting121911903re_futing
reluming11310013re_luming
rerouting10311873rerouting
resuming11310083re_suming
terming104016003ter__ming

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.1561145455.1
2DLD Change Limit148641687.40320078.5
3Display Results68680.0332060.6
 (SQL Overall)178691687.59223536.7
 
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.