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

86 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
treaclier114415(None) 
preachier1646922preachier
treacle939972treacl_e_
treacles1039702treacl_es
treacliest1245382treacliest
treadler936862treadl_er
tremblier1343282tremblier
beachier1538803_beachier
brawlier13267043br_awlier
breacher153011503breac_her
breathier1435383breathier
cleanlier1143363cleanlier
cracklier1744823cr_acklier
crawlier13216873cr_awlier
creakier14328333crea_kier
creamier12319063crea_mier
creasier103210193crea_sier
deadlier1036863_deadlier
drawlier12225253dr_awlier
dreamier11287293drea_mier
drearier9297923drea_rier
earlier72612743__earlier
featlier1136453_featlier
freakier15246483frea_kier
frecklier1842993frecklier
greasier9298083grea_sier
leachier1337253_leachier
mealier93015903_mea_lier
measlier1036013_measlier
nearlier836793_nearlier
peachier1548623_peachier
pearlier1037323_pearlier
preacher153211373preac_her
prealter1048863prea_lter
racier85120973_r_ac_ier
rallier73816273_r_allier
reacher123718293_reac_her
readier83117423_rea_dier
realer63528593_rea_l_er
realiser82512563_rea_liser
realizer172412113_rea_lizer
realter73716313_rea_lter
recaller1039323_recaller
recamier1237603_recamier
recliner103211913_re_cliner
reechier1336673_reechier
relier65826183_re__lier
replier94214973_re_plier
streakier1334843strea_kier
streamier1155763strea_mier
streamliner1352173streamliner
stretchier1544483stretchier
tackier133712523t__ackier
tallier72817213t__allier
teacher123714833t_eac_her
tearier73815613t_ea_rier
techier1269243t_e_chier
tetchier1336453t_etchier
threadier1354473threa_dier
tracer84820233tr_ac__er
tracker133515173tr_ac_ker
trailer73015393tr_ail_er
trampier12318243tr_ampier
trashier113210103tr_ashier
trawler104011903tr_awl_er
treachery1744693treac_hery
treacly1237093treacl__y
treader84113833trea__der
treadle8310103treadl_e_
treadled1067123treadl_ed
treadlers1045893treadl_ers
treadles939703treadl_es
treadling1137503treadling
treasurer944253treasurer
treater74219833trea__ter
treaties8316983trea_ties
trembler1235363trembl_er
trencher13279313trenc_her
trendier937913tre_ndier
tressier847963tre_ssier
trevallies1343463trevallies
trickier143010233tr_ickier
tricklier15256823tricklier
tweakier1533143twea_kier
vealier102712173_vea_lier
weaklier1534263_weaklier

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 Filter1786911486410.406440125.6
2DLD Change Limit148641867.50019818.8
3Display Results86860.0302866.7
 (SQL Overall)178691867.93622516.5
 
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.