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

140 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
factored143621(None) 
doctored1245612doctored
factoid1338692facto_id
factor11911452factor__
factories14810092factories
factorized2595552factorized
factors12912122factor_s
factory15108342factor_y
facture12108922facture_
factures13129022factures
faltered122810982faltered
favored1455982fa_vored
fractured15125042fractured
hectored1436872hectored
pastored1139962pastored
sectored1138062sectored
vectored1435622vectored
accord1178843_accor_d
accorded14155343_accorded
acorned10238263_ac_orned
acred87126353_ac__red
acted88521733_act__ed
actor71116073_actor__
actorly1246413_actorly
actors81016753_actor_s
adored84714233_a_dored
altered83215733_altered
anchored1438593anchored
antired82316193_antired
arbored103811603_arbored
armored102610473_armored
atoned75417543_a_toned
attired8238913_attired
attorned955353_attorned
authored1238263_authored
autoed7712823_auto_ed
bantered113313633bantered
bartered113113013bartered
battered113315053battered
cactoid12311023cacto_id
cantered113415983cantered
cantoned111411523cantoned
captured1336563captured
cartoned111312833cartoned
catered103117763ca_tered
chored125321883__chored
cored85044223__c_ored
dackered16116893dackered
encored10412103enc_ored
faced117727653fac___ed
faceted13509563fac_eted
facetted1445743facetted
factoids1446243factoids
factorage1543333factorage
factorages1643483factorages
factorial1447023factorial
factoring1537523factoring
factorize2366893factorize
factorizes2486673factorizes
factotum1542443factotum
faggoted1443103faggoted
fagoted1236073fa_goted
faired105915773fa__ired
faithed1437163fait_hed
fallowed15127753fallowed
falterer11239853falterer
fantod102010033fanto__d
fared95842343fa___red
farrowed1545283farrowed
farted105121783fart__ed
fasted105320953fast__ed
fastened12257853fastened
fated95632133fa_t__ed
fathered151510433fathered
fathomed1744733fathomed
fatted105419843fa_t_ted
fattened12268283fattened
favorer1355883fa_vorer
favoured1533963favoured
featured1237683featured
festered122512103festered
fettered12259493fettered
filtered12259043filtered
flattered13188623flattered
flavored1554573flavored
floored11268683f_loored
fostered122210443fostered
fracted1339373fract__ed
fractioned1644613fractioned
fracture13147123fracture_
fracturer14134623fracturer
fractures14147233fractures
gartered10319583gartered
hachured1744393hachured
haltered123112553haltered
harbored1438633harbored
hatred104814333ha_t_red
labored102810243la_bored
lackered15108673lackered
lactated1138863lactated
lactone9311393lactone_
lactones10311223lactones
lactose969473lactose_
lactoses1039813lactoses
lectured11127223lectured
majored1735853ma_jored
martyred1434283martyred
mastered112614003mastered
mattered112412903mattered
matured10310033ma_tured
mentored1138003mentored
motored1039933_motored
nacred95212493nac__red
nattered92011623nattered
natured838963na_tured
paltered113012483paltered
pastured1138233pastured
pattered112714203pattered
pictured1346573pictured
proctored1446413proctored
raftered1237663raftered
rancored1137223rancored
raptured1155463raptured
razored1736333ra_zored
restored96417193restored
sacred94917103sac__red
savored1158343sa_vored
scored94621133_sc_ored
stored75524213__stored
succored13135173succored
tabored102810563ta_bored
tailored936203tailored
tattered92011443tattered
tattooed944573tattooed
tutored837553_tutored
vapored1336923va_pored
waitered1238753waitered
wantoned12117223wantoned
watered113014953wa_tered
yattered12239533yattered

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 Filter1786911461620.313570897.8
2DLD Change Limit1461621409.34315644.0
3Display Results1401400.0632222.2
 (SQL Overall)1786911409.71918385.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.