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

133 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
perform143928(None) 
performs1547481performs
preform1439611preform
aeriform1346092aeriform
deform1259622de_form
deiform1336692deiform
paraform1546932paraform
pediform1645182pediform
perforce1544962perforce
performed17155302performed
performer16145132performer
piriform1555752piriform
preforms1537402preforms
prereform1644302prereform
pyriform1844402pyriform
reform11312712re_form
aciform1446013aciform
aliform1247033aliform
auriform1345183auriform
ausform1245233ausform
before11410153be_fore
beworm1339993be_worm
biform1368123_biform
conform14310463conform
defoam1238563de_foam
deforms1337803de_forms
deworm1249533de_worm
earworm1238743earworm
eelworm1245523eelworm
effort1238623_effort
enorm74415643_e_norm
error53712233_error_
errors63311313_errors
fervor1235643fervor_
fervors1336233fervors
form95836873___form
freeform1644703freeform
inform11310153_inform
isoform1244963isoform
leafworm1653913leafworm
lyriform1643543lyriform
misform1437513misform
outperform17132023outperform
oviform1544813oviform
paraforms1645563paraforms
parlor8312673parlor_
parlors9312913parlors
peafowl1543193peafowl
percoid12312313percoid
perdure10379623perdure
pereon83517453pereo_n
pereons92815003pereons
perfect141010833perfect
perfidy1635273perfidy
perforate1459463perforate
performers17164103performers
performing1844943performing
perfume1446503perfume
perfumy1763933perfumy
perfuse1247663perfuse
pergola1067623pergola
periderm1346803periderm
period9314983perio_d
periods10312243periods
perjure16327963perjure
perjury19244253perjury
perm85834633pe___rm
pernod9310453perno_d
pernods1038483pernods
peroral9314793per_oral
peroxy1838253per_oxy
perron83216623perro_n
perrons93115483perrons
perry105222713per__ry
person83517873perso_n
persona92812453persona
persons93717013persons
perter84422283perter_
perturb1146003perturb
pervert12315583pervert
piciform1764993piciform
piedfort1444873piedfort
piefort1249533piefort
piliform1555473piliform
pinworm1467183pinworm
pisiform1564963pisiform
planform1544753planform
platform1544583platform
plexiform2342313plexiform
postform1556213postform
prearm104512353p_rearm
preboom1348253preboom
prefer113813203prefer_
prefers123713333prefers
prefire124012813prefire
preformat1646363preformat
preformed17176203preformed
preinform1644753preinform
presort95219543presort
preterm11310163preterm
pretor8315753pretor_
pretors9316813pretors
prewarm14479613prewarm
prework164210913prework
preworn124711223preworn
prior74316173p_rior_
priors83914483p_riors
priory114110263p_riory
proem94818273p_r_oem
proforma1545433proforma
prom87631703p_r_o_m
proreform1643903proreform
purport1159393purport
reforms1239823re_forms
reinform1346193reinform
reniform1346233reniform
retiform1345863retiform
serfdom1344213serfdom
setiform1345003setiform
superfarm1686133superfarm
superfirm1676203superfirm
telford1145153telford
teraohm1244783teraohm
termor84412513termor_
termors94712773termors
terraform1443593terraform
terror63811733terror_
terrors73112213terrors
triform1237853triform
uniform1247053uniform
variform1645003variform
vermiform1953313vermiform
webworm1744313webworm

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340271336.37621020.5
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.84226116.8
 
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.