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

88 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
tabloids114616(None) 
tabloid1048261tabloid_
haloids113012552ha_loids
haploids1437362haploids
labroids1155842labroids
tabanids1144962tabanids
ablins8316193_abl_ins
alcids94812293_a_lcids
allods73615083_allo_ds
aloins65022203_a_loins
ambroids1346503ambroids
amyloids1446003amyloids
aroids75118223_a_roids
avoids104410203_a_voids
bebloods13115233bebloods
blonds95213343__blonds
bloods94614843__bloods
carloads1138393carloads
ceboids1237653ceb_oids
cheloids1438033cheloids
colloids11310173colloids
cuboids1236723cub_oids
cycloids1647043cycloids
diploids1247843diploids
euploids1157243euploids
factoids1446243factoids
fibroids1445853fibroids
gadoids1036873ga_doids
ganoids939333ga_noids
gobioids1243873gobioids
halids104016133ha_l_ids
haloid104317763ha_loid_
haploid1339833haploid_
haploidy1754273haploidy
hyaloids1545993hyaloids
keloids1288663_keloids
labroid1038823labroid_
loids66220713___loids
mastoids1177873mastoids
mattoids1196183mattoids
meloids10911453_meloids
metalloids1344863metalloids
oxbloods1842753oxbloods
payloads1445293payloads
salpids1038193sa_lpids
sarcoids1137803sarcoids
sloids73712693__sloids
tabanid1047333tabanid_
tabards10310383tab_ards
tabbies112913503tab_bies
tabbis102910863tab_bi_s
tabetics1245683tabetics
tabid84418263tab__id_
tablas83716163tabl__as
tableaus1054853tableaus
tabled94020043tabl_ed_
tables84524893tabl__es
tablets94714383tabl_ets
tabling103216033tabl_ing
tabooed10267383tabooed_
tabooing11186313tabooing
taboos83815433tab_o_os
taborins103310223taborins
tabors84517113tab_o_rs
tabours94110093tab_ours
tabulis938833tabuli_s
tailfins1135443tailfins
tailors73212393tailo_rs
tailskids1442053tailskids
tailwinds1342353tailwinds
talions7314113ta_lions
talkies113415733ta_lkies
tallies73624603ta_llies
tallis63319963ta_lli_s
tallits73215993ta_llits
tallols73311363tallo_ls
tallows103313743tallo_ws
talons64019443ta_lo_ns
tatsois748373tatsoi_s
thalloid1246283thalloid_
thyroids1546003thyroids
toluids835323t_oluids
toroids8310653t_oroids
toxoids1535213t_oxoids
triploids1245893triploids
typhoids1745493typhoids
vanloads1264163vanloads
warlords1245303warlords

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.436409841.7
2DLD Change Limit146162887.23320207.7
3Display Results88880.0461913.0
 (SQL Overall)178691887.71523161.5
 
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.