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

224 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
prewired1435847(None) 
prefired144310751prefired
prewire124311131prewire_
prewires133811011prewires
rewired115413281_rewired
precised133213412precised
precited133013812precited
precured1339992precured
predried12309572predried
prefiled143310572prefiled
prefire124012812prefire_
prefires134313282prefires
prefixed21357692prefixed
premiered14237082premiered
premised133013192premised
premixed20338002premixed
prepared132210862prepared
presided12410552presided
prevised143611072prevised
prewarmed17104562prewarmed
prewarned1594772prewarned
preworked1954652preworked
refired115116992_refired
rehired115013152_rehired
retired84620142_retired
rewire95421402_rewire_
rewires104717112_rewires
bemired123410633_bemired
bewared13310113_bewared
brewed125411873brew__ed
brewises1337213brewises
credited1238253credited
creviced1634453creviced
crewed125316553crew__ed
deaired9411533_deaired
desired9311983_desired
grecized2134433grecized
hardwired1742873hardwired
heired103813043_he_ired
paired95017523p__aired
peered93819483p_e_ered
peined94918843p_e_ined
peised94817683p_e_ised
perdured12287383perdured
periled10316313p_eriled
perjured18286263perjured
perspired1444203perspired
petered103314963p_etered
poetised1138523poetised
poetized2037983poetized
powered132911643p_owered
praised104214813pr_aised
prawned1346743praw_ned
preached163412063preached
preacted132710943preacted
preaged11612333pre_aged
prearmed1397993prearmed
prebaked1737173prebaked
prebid113512843prebi__d
prebilled1445063prebilled
prebind123810643prebi_nd
prebirth1543463prebirth
preboiled1455783preboiled
preceded1438283preceded
precipe133012123precipe_
precipes143212213precipes
precise113518173precise_
preciser123411663preciser
precises123218333precises
precoded1438863precoded
precure11312553precure_
precures12312903precures
predated12513273predated
predicted1538913predicted
predive13511083predive_
predries112714383predries
preed85128113pre___ed
preedited1337633preedited
preened103214983pre_ened
prefaced1638423prefaced
prefaded1537823prefaded
preferred1555003preferred
prefigured1743313prefigured
prefile123413183prefile_
prefiles133113443prefiles
prefilled1535513prefilled
prefixes20389233prefixes
preformed17176203preformed
preguided1443923preguided
prelife1279943prelife_
prelives13310383prelives
preluded1236463preluded
premed114617753pre__med
premie103617993premi_e_
premier113515633premi_er
premiere12249233premiere
premieres13288233premieres
premiers122911653premiers
premies113823063premi_es
premise113818553premise_
premises123018273premises
premixes193110083premixes
prenticed14118063prenticed
preowned1435213preowned
prepare111913623prepare_
preparer12169643preparer
prepares122014163prepares
prepaved16177223prepaved
prepped11329893pre_pped
prepreg12165963pre_preg
prepriced1676633prepriced
prerinsed1246323prerinsed
presaged1238803presaged
prescored14409403prescored
preserved15107563preserved
preside10715613preside_
presider11410423presider
presides11414913presides
presifted1536873presifted
presliced1435973presliced
presorted1239453presorted
pressed103317313pre_ssed
pressured1237333pressured
prestored125111673prestored
presumed1337973presumed
pretaped13339133pretaped
prettied1159253prettied
pretyped16306123pretyped
preunited1246803preunited
prevailed1536043prevailed
preview1536473previ_ew
previewed1843413previewed
previse123713793previse_
previses133814283previses
prevued1337143pre_vued
prewar114712573prewar__
prewarm14479603prewar_m
prewarms15406723prewarms
prewarn124410143prewar_n
prewarns13456943prewarns
prewashed1843923prewashed
preweighed2042213preweighed
prewiring1547893prewiring
prework164210903prewor_k
preworks17599003preworks
preworn124711213prewor_n
prewrap14104973prew_rap
prexies163415003prexi_es
preyed125313193pre__yed
priced115018883pr__iced
prided103618033pr__ided
pried84426863pr__i_ed
primed115118913pr__imed
prised94322203pr__ised
prized184415393pr__ized
procured1336603procured
profiled14338523profiled
profited14279973profited
promised133010873promised
propined133111503propined
provided1536843provided
prowled13309903prow_led
purebred1344253pure_bred
reared75930013_re_ared
rebored105015883_rebored
rebred95816353_re_bred
recited104319103_recited
redried93714893_redried
refiled114318653_refiled
refined114720003_refined
refire95419473_refire_
refires104820313_refires
refixed183611153_refixed
refried113513873_refried
rehire95415863_rehire_
rehires105016113_rehires
reined74425523_re_ined
reived104518133_re_ived
relied74926233_reli_ed
relined85321933_relined
relived115114683_relived
remised103516843_remised
remixed173510743_remixed
reoiled84316853_reoiled
repaired1148953_repaired
repined104918773_repined
required18156833_required
resided95217703_resided
resiled84621983_resiled
resined84522653_resined
resited85122423_resited
resized174614903_resized
respired1148993_respired
retied75924983_reti_ed
retiled84420513_retiled
retimed104714653_retimed
retire64927013_retire_
retiree75019083_retiree
retirer74715013_retirer
retires74726213_retires
retried84419153_retried
revered112819333_revered
reviled114417923_reviled
revised113815483_revised
revived144211653_revived
rewaked153811903_rewaked
reward106017633_rewar_d
rewarded13229523_rewarded
rewarmed14257433_rewarmed
rewaxed18409343_rewaxed
rewed95425453_rew__ed
rewiden1137533_rewiden
rewind104715883_rewi_nd
rewinded13277673_rewinded
reword106321403_rewor_d
reworded13228103_reworded
rewore938030153_rewore_
reworked16247773_reworked
sewered112911243_sewered
skewered1634213skewered
speired103811103spe_ired
unretired1046433unretired
upreared1137073upre_ared
wired95327643___wired

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.1561145455.1
2DLD Change Limit1461622247.31319986.6
3Display Results2242240.0962333.3
 (SQL Overall)1786912247.56523620.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.