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

130 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
predicting164987(None) 
predicating1749651predicating
crediting1338842credi_ting
preacting142412532pre_acting
predating13514652pred_ating
prediction15410302prediction
predictions1649652predictions
predictive1847422predictive
preediting1447932preedi_ting
prelecting15310162prelecting
presifting1638082presifting
redacting13612302_redacting
addicting1485073_addicting
coediting1338333coedi_ting
dedicating1539143_dedicating
deducting1436843_deducting
depicting1537813_depicting
editing9313133__edi_ting
eradiating1248733eradiating
eradicating1556633eradicating
erecting112415063ere__cting
evicting1437483__evicting
indicting1339613_indicting
maledicting1752723maledicting
mediating13311203_mediating
medicating1648953_medicating
pedicuring1643243p_edicuring
perfecting1847513perfecting
permitting1546303permitting
persisting1346653persisting
praelecting1644533praelecting
preaching172811163pre_aching
preadapting1743653preadapting
preadmitting1852763preadmitting
preadopting1743993preadopting
prebidding1783843prebidding
prebilling1595413prebilling
prebinding1696163prebinding
precasting15169833precasting
precenting151012153precenting
precising14413273preci_sing
precutting1546423precutting
prededucting1952553prededucting
predestine1349323predestine
predicant1449393predic_ant
predication16412433predication
predications17411183predications
predicative1947373predicative
predict12315323predict___
predicted1538913predict_ed
predictor1447093predict_or
predictors1547263predictors
predicts1339613predict__s
predigesting1753683predigesting
predrilling1543673predrilling
predrying1645343pred_rying
preelecting1646473preelecting
preempting1745393preempting
preenacting16125373preenacting
preerecting1646143preerecting
preexciting2343753preexciting
preexisting2144223preexisting
prefacing17118743prefac_ing
prefiling1549533prefi_ling
prefiring1559073prefi_ring
prefixing2246783prefi_xing
preheating16310723preheating
prehiring1548383prehi_ring
prejudicing2452193prejudic_ing
prelimiting1645383prelimiting
prelocating1647413prelocating
premiering1547243premiering
premising14412413premi_sing
premixing2157803premi_xing
prenticing1547883prentic_ing
prepacking2145773prepacking
prepasting15168883prepasting
prepricing1746733prepric_ing
preprinting1647413preprinting
prerinsing1347643prerinsing
presenting131013023presenting
presetting131010833presetting
presiding13510903presi_ding
preslicing1546363preslic_ing
presorting1339983presorting
pretasting13239283pretasting
pretesting131810683pretesting
pretexting20206973pretexting
preuniting1347303preuniting
preventing161210263preventing
previewing1943673previewing
prevising15510873previ_sing
previsiting1745543previsiting
prewiring1547893prewi_ring
prewriting1647243prewriting
pricing123417343pr__ic_ing
pricking173212603pr__icking
printing113216083pr__inting
producing1556143produc_ing
profiting1549983profi_ting
projecting22177243projecting
prosecting15189813prosecting
protecting151910213protecting
radiating111112123_radiating
radicating1459063_radicating
reacting113317893_re_acting
readdicting1643813_readdicting
reciting113118073_reci_ting
redating102620173_red_ating
redialing11311843_redialing
redictating1546803_redictating
redipping1555593_redipping
redirecting1545613_redirecting
redocking17126783_redocking
reducing12310203_reduc_ing
reediting11310953reedi_ting
refecting152413353_refecting
refitting132811123_refitting
reindicting1545073_reindicting
rejecting192211153_rejecting
relisting102414353_relisting
relucting1239773_relucting
reminting122315103_reminting
remitting122412623_remitting
resecting122816483_resecting
resifting133512093_resifting
resisting103215313_resisting
resiting93521123_resi_ting
resitting103414873_resitting
retinting102215253_retinting

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.403443402.0
2DLD Change Limit1406031306.44021832.8
3Display Results1301300.0602166.7
 (SQL Overall)1786911306.90325886.0
 
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.