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 “factoids” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
factoids144624(None) 
factoid1338691factoid_
cactoid12311032cactoid_
factions133013062factions
factious13239242factious
factoidal1543322factoidal
factories14810092factories
factors12912122facto_rs
fantods11177622fanto_ds
fucoids1335662fuc_oids
mastoids1177872mastoids
mattoids1196182mattoids
acarids105312243_acarids
accords1247243_accords
acids87121003_ac__ids
actinoids1246303_actinoids
actins86321103_act_ins
actions94218513_actions
actors81016763_acto_rs
aroids75118223_a_roids
avoids104410203_a_voids
bacteroids1545193bacteroids
cancroids1444533cancroids
carotids11229943carotids
cestoids11308273cestoids
coccoids12176793coccoids
cycloids1647043cycloids
cystoids14306733cystoids
dacoits1079073dac_oits
deltoids1045483deltoids
facetious1464443facetious
facias113415803fac__ias
faciends1443573faciends
facies113921593fac__ies
faction122613333fact_ion
factor11911453facto__r
factored1436213factored
factorial1447023factorial
factorials1544693factorials
factoring1537523factoring
factorize2366893factorize
factorizes2486683factorizes
factory15108343facto_ry
factotum1542443factotum
factotums1641923factotums
facts107021893fact___s
factures13129023factures
faitours1134263faitours
fanfolds15104073fanfolds
fantails1139693fantails
fantod102010033fanto_d_
fantoms12189153fanto_ms
fatbirds1443413fa_tbirds
fatties103018203fa_tties
fatwoods1585953fatwoods
fibroids1445843fibroids
fictions132410743fictions
fractions1449103fractions
fractious1456143fractious
fucoid1237893fuc_oid_
fungoids1343993fungoids
gadoids1036873ga_doids
ganoids939333ga_noids
haloids113012553ha_loids
haploids1437363haploids
labroids1155843labroids
lactones10311223lactones
lactoses1039813lactoses
lentoids947443lentoids
mantids103113623mant_ids
mastoid10711233mastoid_
mattoid1079283mattoid_
mucoids1237423muc_oids
noctuids1152863noctuids
pactions122613503pactions
parotids112610413parotids
parotoids1256953parotoids
patois84319363pa_toi_s
placoids1347343plac_oids
sarcoids1137803sarcoids
sautoirs834923sautoirs
tabloids1146143tabloids
tactics1149323tact_ics
tactions102912423tactions

Search took 9 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.1701051123.5
2DLD Change Limit146162848.23617746.7
3Display Results84840.0302800.0
 (SQL Overall)178691848.43621182.0
 
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.