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

89 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
replasters124553(None) 
replaster1136581replaster_
plasters103518132__plasters
relaters83218152re_la_ters
remasters11310582re_masters
repeaters112811992repea_ters
replacers13266832repla_cers
replastered1442482replastered
replates102919272repla_te_s
ballasters1245093ballasters
blasters104116143__blasters
deflaters13298703defla_ters
delusters1035983de_lusters
depleters12327543depl_eters
easters75125683_e__asters
elaters74420193_e_la_ters
enlisters937113_enlisters
feasters11511563fe__asters
implanters1484153implanters
lasters75627693___lasters
pasters94531733__p_asters
piasters102912813__piasters
pilasters1138223_pilasters
plaisters1137813__plaisters
plaiters103512633__plaiters
planters102915323__planters
plashers133813453__plashers
plaster93318693__plaster_
plastery13279703__plastery
platers93924093__pla_ters
platters103415283__platters
prepastes13128823prep_aste_s
rasters74629023r___asters
realisers9248323realis_ers
realters83614043re__alters
rebaters103413943re_ba_ters
recanters112310483re_canters
recharters1555423recharters
reclaimers1443593reclaimers
redbaiters1343603redbaiters
refastens1244753re_fastens
reflates113115663refla_te_s
registers1038893re_gisters
reheaters122010273rehea_ters
relapsers1164123re_lapsers
relater73723143re_la_ter_
relates73731433re_la_te_s
relators83316133re_la_tors
relaxers15298263re_la_xers
releasers937323releas_ers
reletters9138783re_letters
remaster10311473re_master_
repairers1135283rep_airers
repapers1258833rep_a_pers
repartees1147253rep_artees
repasses101810373rep_asse_s
repasted112611533rep_aste_d
repasts93611933rep_ast__s
repattern1143663rep_attern
repatterns1242493rep_atterns
repealers11278843repea_lers
repeater102615443repea_ter_
repenters112511553rep_enters
replacer12279743repla_cer_
replaces123114123repla_ce_s
replanted1248063replante_d
replants102811243replant__s
replastering1553413replastering
replate93420053repla_te__
replated112817523repla_te_d
repleaders1344033repleaders
repletes102812473repl_ete_s
repliers103710163repl__iers
reporters1139173rep_orters
reposers102911603rep_os_ers
repressers1256883repressers
reprinters1295793reprinters
repulsers1144713repuls_ers
requesters1944323requesters
resisters9310453re_sisters
reslates83619503resla_te_s
resters74130403re___sters
retastes82212903re_taste_s
roasters83615933r__oasters
splashers1445283_splashers
splatters11327543_splatters
teatasters1043883teatasters
webcasters1742143webcasters
webmasters1742913webmasters

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.406440125.6
2DLD Change Limit140603895.90623806.8
3Display Results89890.0461934.8
 (SQL Overall)178691896.35828104.9
 
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.