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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

138 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
precasting1516983(None) 
prepasting15168881prepasting
pretasting13239281pretasting
recasting122414231_recasting
breasting1239582bre_asting
forecasting1744472forecasting
preacting142412532pre_acting
precenting151012152precenting
precessing1598742precessing
precising14413272precis_ing
precutting1546422precutting
predating13514652preda_ting
pretesting131810682pretesting
prewashing1944942prewashing
recanting122414822_recanting
repasting122312842_repasting
retasting102513412_retasting
casting104628343___casting
creasing113314443cre_as_ing
creating113921953cre_a_ting
cremating14312193crema_ting
cresting114017043cre__sting
crevassing1643533crevassing
decanting132510633_decanting
demasting1338453_demasting
deprecating1777283depreca_ting
easting84924303__e_asting
erecting112415063erec__ting
feasting122011323_fe_asting
foretasting1554423foretasting
greasing102811393gre_as_ing
imprecating1844903impreca_ting
linecasting14102783linecasting
miscasting1557073miscasting
overcasting1748513overcasting
pasting103826553p___asting
percussing1545223percussing
persisting1346653persisting
placating1438513placa_ting
pleasing112611593ple_as_ing
pleating112916053ple_a_ting
prating103424453pr__a_ting
preaching172811163pre_aching
preadapting1743653preadapting
prearming14139223pre_arming
preassign1244573pre_assign
prebaking1838063preba_king
precast11314853precast___
precasts1239453precast__s
precative16312573preca_tive
precaution1447243precaution
precautions1546553precautions
preceding15129363prec_eding
precharging2043753precharging
precluding1644173precluding
precoding15109733prec_oding
precooking1945043precooking
precooling1545963precooling
precreasing1645703precreas_ing
precuring1439423prec_uring
predestine1349323predestine
predicating1749653predica_ting
predicting1649873predicting
preediting1447933preediting
preempting1745393preempting
preenacting16125373preenacting
preexisting2144223preexisting
prefabbing2042583prefabbing
prefacing17118743prefa_cing
prefading16149033prefa_ding
preheating16310723preheating
prelecting15310163prelecting
prelocating1647413preloca_ting
premising14412413premis_ing
prepacking2145773prepacking
preparing14311643prepa_ring
prepaving1787233prepa_ving
prepaying1747973prepa_ying
preplanting1645933preplanting
presaging1339393presa_ging
presenting131013023presenting
presetting131010833presetting
presifting1638083presifting
presorting1339983presorting
pressing112516443pre__ssing
pretaping1439133preta_ping
pretexting20206973pretexting
preuniting1347303preuniting
prevailing1656723prevailing
prevaluing1644273prevaluing
preventing161210263preventing
prevising15510873previs_ing
previsiting1745543previsiting
prewarming18145173prewarming
prewarning16135193prewarning
prewriting1647243prewriting
priesting1239483pr_iesting
probating14311193proba_ting
processing15108183processing
pronating12313763prona_ting
prorating12314283prora_ting
protesting131910253protesting
reacting113317893_re_acting
rebaiting12311643_rebaiting
rebating112418343_reba_ting
recalling122211903_recalling
recaning111416693_reca_ning
recapping1636453_recapping
recessing12611013_recessing
recharting1637213_recharting
reciting113118073_rec_iting
reclasping15105083_reclasping
recoating121317463_recoating
recrating121318793_recrating
recusing112512883_recus_ing
recutting1239483_recutting
redacting13612303_redacting
redating102620173_reda_ting
reesting93118273_re_esting
rehashing1647113_rehashing
relating92725443_rela_ting
relisting102414353_relisting
remating112322413_rema_ting
renesting102514703_renesting
repassing12249423_repassing
resisting103215313_resisting
resting85031183_re__sting
retesting102614603_retesting
revesting132814123_revesting
rewashing1676903_rewashing
roasting93012703_r_oasting
telecasting1443793telecasting
treating92519613tre_a_ting
typecasting1951963typecasting
upcasting1434823_upcasting
webcasting1842483webcasting
wresting123811833wre__sting
yeasting12188923_ye_asting

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 Limit1406031385.81324187.7
3Display Results1381380.0632190.5
 (SQL Overall)1786911386.28228444.9
 
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.