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

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

104 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
preadaptations195175(None) 
preadaptation1852141preadaptation_
adaptations1464573___adaptations
coadaptations1851683_coadaptations
maladaptations1961333maladaptations
adaptation1355224___adaptation_
coadaptation1751964_coadaptation_
maladaptation1861384maladaptation_
preadapting1743654preadap__ti_ng
precipitations2085394precipitations
predations13812154pre_d___ations
predications17411184pre_d_ications
premeditations1955014premeditations
preparations1648314pre_pa_rations
presentations1548134pre_sentations
recantations1448874_re_cantations
replantations1544864_replantations
adaptational1572795___adaptational
adaptions1245225___adap__tions
coaptations1547545___coaptations
crepitations1647475cre__pitations
decantations1547945_de_cantations
decapitations1847665_de_capitations
devastations1645825_de_vastations
eradications1549305er_ad_ications
exaltations1847295__e_xaltations
frequentations2652245frequentations
gradations1286865gr_ad___ations
graduations1385235gr_ad__uations
gravitations1644765gr_a_vitations
irradiations1394885irrad__iations
meditations1449335_me_d_itations
ornamentations1673255ornamentations
palpations1437655p__a_lp_ations
palpitations1645525p__alpitations
peltations12311555p_e___ltations
perambulations2053075perambulations
permutations1646505p_e_rmutations
placentations17103635p_lacentations
plantations1347475p___lantations
preadaptive1952915preadap__ti_ve
preadapts1444005preadap__t___s
preadmissions1852365pread_missions
preadmitting1852765preadmit_ti_ng
preadopting1743995preadop__ti_ng
precautions1546555pre_ca__utions
precipitation1966225precipitation_
predation12313465pre_d___ation_
predestinations1865005pre_destinations
predication16412435pre_d_ication_
predictions1649655pre_d__ictions
predigestions1773285pre_digestions
predilections1853565pre_dilections
predominations19105545predominations
preemptions17134855pre_emp__tions
prefabrications2492435prefabrications
prefigurations2053025prefigurations
preformations2045715pre_formations
prelibations16127625pre__libations
premeditation1855705premeditation_
prenominations18105765prenominations
preoccupations2252015preoccupations
preoptions1447645pre__op__tions
preordinations1765715preordinations
preparation1549275pre_pa_ration_
preportions1548265pre___portions
presentation1448995pre_sentation_
preservations1895545pre_servations
presumptions18153885presump__tions
prevarications2154745prevarications
proclamations1952695procla_mations
profanations17175255pr_ofa_nations
propagations1745555pr_opa_gations
protestations1555815pr_otestations
radiations11311925_r_ad__iations
reactivations18176145_reactivations
readapting1445155_readap__ti_ng
realizations21415535_rea_lizations
reallocations1553805_reallocations
reanimations1468785_rea_nimations
reannexations2052835_reannexations
reapportions1653655_rea_pportions
recantation1349865_re_cantation_
recitations13314205_re__citations
reclamations1645715_recla_mations
recomputations20104105_recomputations
redactions1359135_re_da__ctions
reeducations1545475_reed_ucations
reevaluations1654275_reevaluations
refutations1448675_re__futations
relaxations1845645_re_la_xations
reluctations1446755_re_luctations
reparations13611665_re_pa_rations
repartitions1444965_re_partitions
replantation1445525_replantation_
reputations13410735_re__putations
reradiations1349495_re_radiations
restations10315845_re___stations
retaliations12511405_re_taliations
retardations1396515_re_tardations
revaluations1557635_re_valuations
revegetations17114715_revegetations
temptations1545415_te__mptations
trepanations1444575tre_pa_nations

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 Filter178691950240.360496363.9
2DLD Change Limit950241046.34314980.9
3Display Results1041040.0631650.8
 (SQL Overall)1786911046.76626410.1
 
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.