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

144 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
permuted133671(None) 
permute1138791permute_
permutes1238711permutes
perdured12287402perdured
perfumed1654542perfumed
perfused1445832perfused
perjured18286272perjured
permeated1439372permeated
permed115217352perm__ed
permitted1446652permitted
peruked14367892per_uked
perused103112192per_used
rerouted9311142rerouted
aerated85322373aer_ated
apertured1244063apertured
bemused1236713be_mused
berated104422133ber_ated
bermed115217723berm__ed
berouged1235323berouged
besmutted1442683besmutted
bruted95113263_br_uted
cerated103922473cer_ated
commuted15288983commuted
cornuted1137473cornuted
cremated133412963cremated
debuted11379333de_buted
demoted114313543de_moted
deputed114610173de_puted
derated93623503der_ated
deratted1048403deratted
eluted74915263_e_luted
emoted94614923_e_moted
erected103213993_erected
ermined10410603_ermined
eructed10228653_eructed
erupted10207163_erupted
fermate122813003fermate_
fermented1546623fermented
ferreted1236333ferreted
ferruled1263923ferruled
feruled11318423fer_uled
gemmated14336293gemmated
grouted94111503_grouted
helmeted1435833helmeted
merited10313853mer_ited
murmured1343113murmured
muted85023383___muted
oersted839553oer_sted
operated11512223oper_ated
palmated132511003palmated
parented11912213parented
pargeted1238683pargeted
parqueted2144223parqueted
parroted1158843parroted
parted94228683par__ted
pelleted1138203pelleted
pelted94617763pe__lted
pennated11299543pennated
peplumed1543043peplumed
perched154713243per_ched
percussed1444803percussed
perdue93912633perdu_e_
perdues103511333perdu_es
perdure10379623perdure_
perdures11289683perdures
perfected1736643perfected
perfume1446503perfume_
perfumer1574553perfumer
perfumes1555893perfumes
perfuse1247663perfuse_
perfuses1358663perfuses
periled10316323per_iled
perilled11410113perilled
perimeter1349563perimeter
peripter1278753peripter
perished14310083perished
perjure16327963perjure_
perjurer17285903perjurer
perjures17268083perjures
perked134617693per__ked
perlite9317323perlite_
perlites10316363perlites
permeate12311613permeate_
permeates13311773permeates
permit10321683permit__
permits11314003permit_s
permittee1346683permittee
permitter1345963permitter
permuting1446553permuting
perorated12412463perorated
persecuted1543503persecuted
persisted1247143persisted
persuade1145853persuade
persuaded1344373persuaded
perter84422283per__ter
perturbed1443353perturbed
peruke123210393per_uke_
perukes133210113per_ukes
peruse84016843per_use_
peruser93511373per_user
peruses94018163per_uses
pervaded1535373pervaded
perverted1546103perverted
petted94121523pe__tted
pirated102515613pir_ated
polluted1135433polluted
ported94223243por__ted
pouted94021393p__outed
prated94924923p_r_ated
preacted132710943preacted
precited133013813precited
precured1339993precured
predated12513273predated
preempted1644683preempted
preluded1236473preluded
premed114617763prem__ed
premised133013193premised
premixed20338013premixed
premune1138933premune_
presumed1337973presumed
prevued1337143prevu_ed
printed104016373p_rinted
promoted13310543promoted
prompted1536903prompted
pruned93413113p_r_uned
pursued10388133pursu_ed
refuted114313803re_futed
remated103522473re_mated
reputed104613483re_puted
rerented92516163rerented
reroute7313963reroute_
reroutes8312223reroutes
routed75624333__routed
seriated92717023seriated
serrated92513433serrated
spermatid1448043spermatid
sprouted1136393sprouted
tempted12317283te_mpted
termed94816703term__ed
termite9313893termite_
termites10313693termites
verdured13255763verdured
vermuth1543533vermut_h
vermuths1642603vermuths

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621446.89021213.6
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.35924282.0
 
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.