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

71 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
preheaters155719(None) 
preheater1448911preheater_
reheaters122010271_reheaters
preheated1539812preheate_d
preheats1339412preheat__s
presenters1239862presenters
pretheater1545542pretheater_
preventers1547392preventers
reheater113413032_reheater_
repeaters112811992_repeaters
beefeaters1553233beefeaters
beheaders1545153_beheaders
cheaters133613513__cheaters
crabeaters1444503crabeaters
defeaters13289103_defeaters
freshwaters2052213freshwaters
greeters92610113gre_e_ters
heaters104225223___heaters
overeaters1348633overeaters
perfecters1745433perfecters
permeates13311773permeate_s
permeators1447403permeators
perverters1544963perverters
pleaters103613793p__leaters
praters94921653pr___aters
prealters1147773pre_alters
preavers13910263pr__eavers
precentors1488343precentors
preceptors1657053preceptors
predates11615813pre_date_s
predators12310083pre_dators
predeaths1544743predeat_hs
preeners102712813pre_e_ners
prefacers1636293pre_facers
preferrers1542983preferrers
preheat12413893preheat___
preheating16310723preheating
prelates10418573pre_late_s
prelectors1447863prelectors
preparers13197673pre_parers
presagers1236943pre_sagers
presbyters1743183presbyters
presentees1247923presentees
presenter11311643presenter_
preservers15115693preservers
presters103419003pr__esters
pretenders1345243pretenders
preventer1438593preventer_
protecters14168253protecters
protesters12169383protesters
rebaters103413943_re_baters
reenters82915303_re_enters
rehears103312773_rehea__rs
rehearsers13273863_rehearsers
reheated122415003_reheate_d
reheats104513523_reheat__s
rejecters18257543_rejecters
relaters83218153_re_laters
releasers937323_releasers
reletters9138783_reletters
repealers11278843_repealers
repeater102615443_repeater_
repenters112511553_repenters
resetters9129463_resetters
retreaters1047543_retreaters
revealers12318243_revealers
reverters122710433_reverters
seedeaters1144903seedeaters
superheaters1755393superheaters
theaters114211903__theaters
treaters83615843tr__eaters

Search took 7 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 Filter1786911406030.1561145455.1
2DLD Change Limit140603716.15622840.0
3Display Results71710.0302366.7
 (SQL Overall)178691716.34228175.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.