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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
reappropriating1991901reappropriating_
appropriating1783493__appropriating_
expropriating2553244_e_xpropriating_
reappropriate1682424reappropriat___e
reappropriated1872104reappropriat__ed
reappropriates17102254reappropriat__es
appropriation1653825__appropriati_on
appropriations1763175__appropriations
appropriative1963025__appropriati_ve
reappointing17122935reapp_o__inting_
appreciating1954086__appr_eciating_
approbating1844586__appro__bating_
appropriate1464286__appropriat___e
appropriated1663496__appropriat__ed
appropriately1962656__appropriat_ely
appropriateness1891586__appropriateness
appropriates1564066__appropriat__es
appropriator1563596__appropriat__or
appropriators1663376__appropriat_ors
approximating2761806__approximating_
expropriation2453996_e_xpropriati_on
expropriations2553326_e_xpropriations
inappropriate16112276inappropriat___e
inappropriately2171836inappropriat_ely
reapportioning1961626reapp_ortioning_
reappraising1762846reappr__ai_sing_
reapproving1982886reappro____ving_
reciprocating2052856recipro__cating_
repatriating1545456re__p_atriating_
repopulating1744486re__p_opulating_
reprobating1647106re__pro__bating_
reprograming1863906re__progr_aming_
unappropriated1872076unappropriat__ed
apocopating1853247__apocop__ating_
appointing1545327__app_o__inting_
appropriable1762717__appropria__ble
camphorating2252567_campho_r_ating_
depopulating1853737de__p_opulating_
depreciating1845037de__pr_eciating_
deprograming1963367de__progr_aming_
earsplitting1551387_ea__rsplitting_
evaporating1744197_evap_o_r_ating_
excoriating2145487_e__xco_riating_
expatriating2253067_e_xp_atriating_
expropriate2253787_e_xpropriat___e
expropriated2452997_e_xpropriat__ed
expropriates23103407_e_xpropriat__es
expropriator2363017_e_xpropriat__or
expropriators2462897_e_xpropriat_ors
misappropriate19172127misappropriat___e
misappropriated21172007misappropriat__ed
misappropriates20192007misappropriat__es
perorating13313137___pero_r_ating_
preapproving1951627preappro____ving_
preprinting1647417____preprinting_
preprograming2162487pre__progr_aming_
procreating1647697____procreating_
propagating1754887____propagating_
propitiating1755007____propitiating_
prorating12314287____pro_r_ating_
reaccelerating19101847reacceler_ating_
reaccrediting1961487reaccr_edi_ting_
readopting1465517rea__dop___ting_
reafforesting2051397rea_ffo_resting_
reaggregating1552567reaggr__egating_
reallocating1573667rea_llo__cating_
reanointing1244997rea__no__inting_
reappearing1643947rea_p__p_earing_
reapportion1554037reapp_o_r__ti_on
reapportioned1862257reapp_o_r__tioned
reapportions1653657reapp_o_r__tions
rearresting1245967rea__r__resting_
reassorting1245027rea_sso_r__ting_
reauthorizing2692557reautho_ri_zing_
recuperating1744997recup__er_ating_
redecorating16115057re_deco_r_ating_
redepositing1652827redep_o_si_ting_
reexporting2143427reexp_o_r__ting_
reimporting1644097reimp_o_r__ting_
reincorporating2061887reincorporating_
renegotiating1552247re_nego_tiating_
reoperating1449027re____operating_
reporting12513907re__p_o_r__ting_
repositing13310497re__p_o_si_ting_
reprinting131510587re_____printing_
repristinating1783067re__pristinating_
reprogramming2172927re__programming_
repudiating1546207re__p__udiating_
reradiating1347267re___r_adiating_
rerepeating1447187re___rep_eating_
resprouting1445057re_spro___uting_
retrodicting1654467re__tro_dicting_
retrofitting1653187re__tro_fitting_
retrograding1553417re__trogr_ading_
reverberating1953207re_verber_ating_

Search took 10 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 Filter178691950240.360496363.9
2DLD Change Limit95024959.33010184.8
3Display Results95950.0631507.9
 (SQL Overall)178691959.75318321.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.