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

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

103 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
preinserting154417(None) 
reinserting1256901_reinserting
inserting10914243___inserting
preconcerting2084413preconcerting
preinforming2072693preinforming
preinsert1148573preinsert___
preinserted1443773preinsert_ed
preinserts1243973preinsert__s
preinviting1744363prein_viting
presenting131013023pre__senting
preserving1637363pre__serving
presetting131010833pre__setting
presorting1339983pre__sorting
reasserting1246153_reasserting
reinfecting1745153_reinfecting
reinjecting2144453_reinjecting
reinsertion1145443_reinsertion
reinsertions1245273_reinsertions
reinspecting1763203_reinspecting
reinstating1248113_reinstating
reinsuring1146383_reinsur_ing
reinterring1245363_reinterring
reinventing1545253_reinventing
reinvesting1545323_reinvesting
deserting11713144_de__serting
disserting121310854__disserting
enserfing1345894__e_nserfing
exserting1736664__e_xserting
insetting1079284___insetting
inverting131013224___inverting
perverting1646624p_e_rverting
preabsorbing1951974preabsorbing
prealtering1446174prealter_ing
preassuring1443824preassur_ing
preaverring1743244pre_averring
precasting15169834precas__ting
precensoring1753224precensor_ing
precenting151012154pre__centing
predigesting1753684predigesting
preelecting1646474pre_electing
preenacting16125374preen_acting
preerecting1646144pre_erecting
preferring1645624pre__ferring
preheating16310724pre__heating
preinterview2062024preinterview
prelecting15310164pre__lecting
premiering1547244pre_mier_ing
preordering15124304preorder_ing
prepasting15168884prepas__ting
preponderating2062584preponderating
prerinsing1347644prerins___ing
preselecting1744294preselecting
preselling1338694pre__selling
presettling1444454pre__settling
presifting1638084pre__sifting
pressuring1346514pre_ssur_ing
pretasting13239284pretas__ting
pretesting131810684pre__testing
pretexting20206974pre__texting
pretreating1448894pre_treating
preuniting1347304preun__iting
preventing161210264pre__venting
previsiting1745544previs_iting
priesting1239484pr_i__esting
princeling1544654pr_ince_ling
printing113216084pr_in___ting
prosecting15189814pr__osecting
reassorting1245024_reassorting
reconverting1876404_reconverting
reentering1149984_reenter_ing
reimmersing1642824_reimmersing
reimporting1644094_reimporting
reinciting1347104_rein_citing
reincurring1443404_reincurring
reindexing1943854_reinde_xing
reindicting1545074_reindicting
reinducting1544384_reinducting
reinflating1545994_reinflating
reinforcing1743714_reinforcing
reinforming1784044_reinforming
reinjuring1844424_reinjur_ing
reinnervating1752924_reinnervating
reinsert8313224_reinsert___
reinserted1146684_reinsert_ed
reinserts946424_reinsert__s
reinspiring1443804_reinspiring
reintegrating1554614_reintegrating
reinviting1446214_rein_viting
reiterating12410494_rei_terating
rendering112213184_re_nder_ing
renesting102514704_re_n_esting
reobserving1742764_reobserving
reseating102421534_re__seating
resecting122816484_re__secting
resenting102619294_re__senting
reserving131110644_re__serving
resetting102816294_re__setting
resorting10614614_re__sorting
reverting132315134_re__verting
transecting1447374tr_ansecting
trendsetting1451394trendsetting
trinketing1544154tr_inke_ting
trisecting1345504tr_i_secting

Search took 9 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 Filter1786911247900.420425454.8
2DLD Change Limit1247901037.92315750.3
3Display Results1031030.0631634.9
 (SQL Overall)1786911038.40621257.6
 
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.