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

139 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
perfused144583(None) 
perfumed1654541perfumed
perfuse1247661perfuse_
perfuses1358661perfuses
perused103112191per_used
defused125211092de_fused
effused1434142_effused
percussed1444802percussed
perdured12287402perdured
perfume1446502perfume_
perfumer1574552perfumer
perfumes1555892perfumes
perjured18286272perjured
permuted1336712permuted
peruked14367892per_uked
peruse84016842per_use_
peruser93511372per_user
peruses94018162per_uses
refused115114442re_fused
apertured1244063apertured
aroused84914343_aroused
bemused1236713be_mused
berouged1235333berouged
caroused1149253caroused
censused11184973censused
cereuses1049243cereuses
ceruse83914523cer_use_
ceruses93716233cer_uses
confused1437033confused
defuse105712723de_fuse_
defuser115110503de_fuser
defuses114814593de_fuses
defuzed21447043de_fuzed
deloused1036973deloused
diffused1643483diffused
effuse1234963_effuse_
effuses1335903_effuses
erased74816753_er_ased
excused1736293_excused
ferruled1263923ferruled
feruled11318423fer_uled
fused94820443___fused
groused94712833_groused
infused11329253_infused
interfused1445883interfused
kerfed14358233kerf__ed
overused1249443over_used
parsed96323893par__sed
paused95114963p__aused
peised94817683pe__ised
peplumed1543043peplumed
pepluses1287023pepluses
perched154713243per_ched
percuss1137163percus_s
percusses1346503percusses
perdue93912633perdu_e_
perdues103511333perdu_es
perdure10379623perdure_
perdures11289683perdures
perdus93711273perdus__
perfected1736643perfected
performed17155303performed
perfumers1683713perfumers
perfumery1972383perfumery
perfumy1763933perfu_my
perfusate1444833perfusate
perfusates1543993perfusates
perfusing1565633perfusing
perfusion14105883perfusion
perfusive1744343perfusive
periled10316323per_iled
perilled11410113perilled
perished14310083perished
perjure16327963perjure_
perjurer17285903perjurer
perjures17268083perjures
perked134617693per__ked
permed115217353per__med
permute1138793permute_
permutes1238713permutes
perse75429523per__se_
perses85428063per__ses
persisted1247143persisted
persuade1145853persuade
persuaded1344373persuaded
perturbed1443353perturbed
pertusses1145383pertusses
peruke123210393per_uke_
perukes133210113per_ukes
perusal939193per_usal
perusers10328803per_users
pervaded1535373pervaded
phrased1387383phr_ased
praised104214813p_raised
precised133213413precised
precured1339993precured
prefaced1638423prefaced
prefaded1537823prefaded
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
prefocused1843443prefocused
prefund1335733prefu_nd
prefunded1644693prefunded
preluded1236473preluded
premised133013193premised
prerinsed1246323prerinsed
pressed103317313p_ressed
presumed1337973presumed
prevised143611073prevised
prevued1337143prevu_ed
prised94322203p_r_ised
prissed103311263p_rissed
profuse1237153profuse_
prosed94921093p_r_osed
pruned93413113p_r_uned
purfled13248733purf_led
purposed1335263purposed
pursed95220883pur__sed
pursued10388133pursu_ed
rearoused1047093rearoused
recused104714423re_cused
refuged125410873re_fuged
refuse94817513re_fuse_
refuser104912783re_fuser
refuses104918553re_fuses
refuted114313803re_futed
rehoused1239613rehoused
reinfused1344063reinfused
reraised9312353reraised
rerouted9311143rerouted
reused75419563__reused
roused75426443__roused
suffused1544023suffused
unfused11319513_unfused
uproused1135833uproused
verdured13255763verdured
versed104515513ver__sed
xeruses143010753xer_uses

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621397.87618557.9
3Display Results1391390.0463021.7
 (SQL Overall)1786911398.34521412.9
 
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.