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

91 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
overidentifying2671461overidentifying_
overidentified2262584overidentif_i_ed
overidentifies2162794overidentif_i_es
overidentify2262944overidentify____
reidentifying2151854_re_identifying_
identifying1943495____identifying_
misidentifying2461025_misidentifying_
overidealizing2863455overideali_zing_
overadvertising2371616overadverti_sing_
overclassifying2771286overclassifying_
overdesigning1952716over_de_signing_
oversimplifying2971476oversimplifying_
semideifying2261776_semide__ifying_
certifying1945317_cer____tifying_
credentialing17102797__credentialing_
decertifying2292797_de__certifying_
densifying1844817_____densifying_
desertifying2092877_de__sertifying_
objectifying3051697o___bjectifying_
orientating1245777o__ri_ent_ating_
orienteering1352617o__ri_enteering_
orienteerings1461597o__ri_enteerings
orienting1038727o__ri_ent___ing_
overbeating17410487over_beat___ing_
overbetting1747457over_be_t__ting_
overbreathing22173677overbreat__hing_
overbreathings23171677overbreat__hings
overcounting1846617overcount___ing_
overdecking2246057over_de___cking_
overdecorating2153687over_decorating_
overdemanding2152797over_de_manding_
overdetermined2162457over_de_termined
overdeveloping2461787over_developing_
overdirecting2053747overdirect___ing_
overdrinking2143977over_d__rinking_
overdriving1946097over_d__ri_ving_
overdrying1846547over_d____rying_
overeating141016537over__eat___ing_
overediting1648047over__e_di_ting_
overestimating2054327over__estimating_
overexciting2565337over__exci_ting_
overexercising2782587overexerci_sing_
overexerting2346497overexert___ing_
overextending2553917over__extending_
overfertilizing31101827over_fertilizing_
overheating1849937over_heat___ing_
overhunting1856527over_hunt___ing_
overhuntings1952867over_hunt___ings
overindulging1952257overi__ndulging_
overinflating2053967overi__nflating_
overinforming2252857overi__nforming_
overlending1647617over_len___ding_
overlengthening2371397over_lengthening_
overletting1548017over_le_t__ting_
overmelting1768117over_melt___ing_
overplanting1846977overplant___ing_
overprinting1846877overprint___ing_
overservicing2252737over_servi_cing_
oversetting1548817over_se_t__ting_
overspending1945737overspen___ding_
overstaffing2243657over___staffing_
overstaying1847057over___st_aying_
overstirring1644537over___stirring_
overstudying2043177over___studying_
overstuffing2253057over___stuffing_
oversweetening2171867oversweet_ening_
overtiming1699077over____ti_ming_
overtipping1945237over____tipping_
overtiring141210207over____ti_ring_
overtreating1648557overtreat___ing_
overwearying2244107over_we__arying_
overweening1846237overween____ing_
overweighing2353707over_we__ighing_
overwetting1847257over_we_t__ting_
overwintering2053057over_wint_ering_
personifying2152377_per_son_ifying_
prenotifying2153057__pr__enotifying_
presignifying2351797presi_gn_ifying_
prettifying2044007__pr__ettifying_
recertifying2183237___recertifying_
rectifying1946377___r__ectifying_
reidentified1762937_re_identif_i_ed
reidentifies1663227_re_identif_i_es
reidentify1753137_re_identify____
renotifying1844187___r__enotifying_
resinifying1844357_resi__n_ifying_
retestifying1993417___retestifying_
verbifying2244357_ver____bifying_
verifying1936417_ver_____ifying_
versifying2045037_ver____sifying_
vinifying1944717_v__i__n_ifying_

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.356501941.0
2DLD Change Limit95024919.00310554.7
3Display Results91910.0601516.7
 (SQL Overall)178691919.41918971.3
 
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.