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

177 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
preform143962(None) 
perform1439291perform
preforms1537411preforms
reform11312721_reform
deform1259632_deform
freeform1644712freeform
paraform1546942paraform
performs1547492performs
piefort1249542piefort
piriform1555762piriform
prearm104512352pre_arm
preboom1348252preboom
prefer113813202prefer_
prefers123713332prefers
prefire124012812prefire
preformat1646362preformat
preformed17176202preformed
preinform1644762preinform
prereform1644312prereform
presort95219542presort
preterm11310162preterm
pretor8315752pretor_
pretors9316812pretors
prewarm14479612prewarm
prework164210912prework
preworn124711222preworn
proforma1545432proforma
proreform1643912proreform
pyriform1844412pyriform
reforms1239822_reforms
triform1237862triform
aciform1446023aciform
aeriform1346103aeriform
aliform1247043aliform
arciform1544803arciform
auriform1345193auriform
ausform1245243ausform
before11410153_before
beworm1339993_beworm
biform1368133_biform
conform14310463conform
defoam1238563_defoam
deforms1337803_deforms
deiform1336703deiform
deworm1249533_deworm
enorm74415643__enorm
fireworm1646693fireworm
form95836873___form
gruiform14103383gruiform
inform11310153_inform
isoform1244963isoform
lyriform1643553lyriform
misform1437513misform
oviform1544823oviform
paraforms1645583paraforms
pediform1645193pediform
perforce1544963perforce
performed17155303performed
performer16145133performer
perm85834633p_e__rm
phenom1339473pheno_m
piciform1765003piciform
piedfort1444883piedfort
pieforts1344863pieforts
piliform1555483piliform
pinworm1467183pinworm
pisiform1564973pisiform
planform1544763planform
platform1544593platform
plexiform2342323plexiform
plexor1535253plexor_
plexors1645423plexors
postform1556223postform
praetor938973praetor_
praetors1039833praetors
prearms11369173pre_arms
preboard1338263preboard
preboil1148953preboil
prebook1557523prebook
precode12311853precode
precook1577803precook
precool1139013precool
precoup1336123precoup
precure11312553precure
predry1237873pre_dry
prefab1336243pref_ab
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
prefatory1746693prefatory
prefect141011073prefect
prefile123413183prefile
prefired144310753prefired
prefires134313283prefires
prefix18356853pref_ix
preflame1545913preflame
prefocus1544743prefocus
preformats1744413preformats
preforming1846233preforming
prefroze2264673prefroze
prefund1335733prefund
preinforms1743253preinforms
prelim10311433pre_lim
preload1049813preload
premium13310363premium
premold1247863premold
premolt11312073premolt
premoral1249713premoral
premorse1237553premorse
prenoon9310043prenoon
preop94715873pre_o_p
preops104911943pre_ops
preoral9312673pre_oral
prepare111913623prepare
prerock1536723prerock
prescore124812373prescore
presoak1348453presoak
presold1059603presold
presong1039843presong
presorts105311683presorts
pressor93512883pressor_
pressors103212693pressors
prestore104217353prestore
preterms1237223preterms
pretold1049083pretold
pretrim11310783pretrim
preverb14317063preverb
prewar114712583prewar_
prewarms15406733prewarms
prewarn124410153prewarn
prewire124311143prewire
preworks17599013preworks
preyer114413733preyer_
preyers124412363preyers
prior74316173pr_ior_
priors83914483pr_iors
priory114110263pr_iory
proem94818273pr__oem
prom87631703pr__o_m
rearm75923573_re_arm
rebore86625653_rebore
reborn810016963_reborn
record96117433_record
recork126315493_recork
refer84822143_refer_
refers93921083_refers
refilm114311403_refilm
refire95419473_refire
refold103812113_refold
reforge11259033_reforge
reformat1357653_reformat
reformed14249603_reformed
reformer13217953_reformer
refry114412463_ref_ry
reinform1346203_reinform
remora8414593_remora
reniform1346243_reniform
report85326023_report
resorb84914353_resorb
resort65728623_resort
retiform1345873_retiform
retore67630773_retore
retorn610923433_retorn
retort66831153_retort
rewarm115913493_rewarm
reword106321413_reword
rewore938030163_rewore
rework136619793_rework
reworn98122203_reworn
trefoil1066063trefoil
tremor84210403tremor_
tremors93711233tremors
uniform1247063uniform
ursiform1343763ursiform
variform1645013variform
waveform1943563waveform
wireworm1645893wireworm

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.423422437.4
2DLD Change Limit1340271776.18621666.2
3Display Results1771770.0632809.5
 (SQL Overall)1786911776.67226782.2
 
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.