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
perform143929(None) 
performs1547491performs
preform1439621preform
aeriform1346102aeriform
deform1259632de_form
deiform1336702deiform
paraform1546942paraform
pediform1645192pediform
perforce1544962perforce
performed17155302performed
performer16145132performer
piriform1555762piriform
preforms1537412preforms
prereform1644312prereform
pyriform1844412pyriform
reform11312722re_form
aciform1446023aciform
aliform1247043aliform
auriform1345193auriform
ausform1245243ausform
before11410153be_fore
beworm1339993be_worm
biform1368133_biform
conform14310463conform
defoam1238563de_foam
deforms1337803de_forms
deworm1249533de_worm
earworm1238743earworm
eelworm1245533eelworm
effort1238623_effort
enorm74415643_e_norm
error53712233_error_
errors63311313_errors
fervor1235643fervor_
fervors1336233fervors
form95836873___form
freeform1644713freeform
inform11310153_inform
isoform1244963isoform
leafworm1653913leafworm
lyriform1643553lyriform
misform1437513misform
outperform17132033outperform
oviform1544823oviform
paraforms1645583paraforms
parlor8312683parlor_
parlors9312923parlors
peafowl1543193peafowl
percoid12312323percoid
perdure10379623perdure
pereon83517453pereo_n
pereons92815003pereons
perfect141010833perfect
perfidy1635273perfidy
perforate1459463perforate
performers17164103performers
performing1844943performing
perfume1446503perfume
perfumy1763933perfumy
perfuse1247663perfuse
pergola1067623pergola
periderm1346813periderm
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
piciform1765003piciform
piedfort1444883piedfort
piefort1249543piefort
piliform1555483piliform
pinworm1467183pinworm
pisiform1564973pisiform
planform1544763planform
platform1544593platform
plexiform2342323plexiform
postform1556223postform
prearm104512353p_rearm
preboom1348253preboom
prefer113813203prefer_
prefers123713333prefers
prefire124012813prefire
preformat1646363preformat
preformed17176203preformed
preinform1644763preinform
presort95219543presort
preterm11310163preterm
pretor8315753pretor_
pretors9316813pretors
prewarm14479613prewarm
prework164210913prework
preworn124711223preworn
prior74316173p_rior_
priors83914483p_riors
priory114110263p_riory
proem94818273p_r_oem
proforma1545433proforma
prom87631703p_r_o_m
proreform1643913proreform
purport1159393purport
reforms1239823re_forms
reinform1346203reinform
reniform1346243reniform
retiform1345873retiform
serfdom1344213serfdom
setiform1345013setiform
superfarm1686133superfarm
superfirm1676203superfirm
telford1145163telford
teraohm1244783teraohm
termor84412513termor_
termors94712773termors
terraform1443603terraform
terror63811733terror_
terrors73112213terrors
triform1237863triform
uniform1247063uniform
variform1645013variform
vermiform1953323vermiform
webworm1744313webworm

Search took 10 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.813219792.1
2DLD Change Limit1340271338.11016526.1
3Display Results1331330.0602216.7
 (SQL Overall)1786911338.98319892.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.