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

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

87 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
overidentifying267146(None) 
overidentified2262583overidentif_ied
overidentifies2162793overidentif_ies
overidentify2262943overidentify___
reidentifying2151853_re_identifying
identifying1943494____identifying
misidentifying2461024_misidentifying
overidealizing2863454overideali_zing
overadvertising2371615overadverti_sing
overclassifying2771285overclassifying
overdesigning1952715over_de_signing
oversimplifying2971475oversimplifying
semideifying2261775_semide__ifying
certifying1945316_cer____tifying
credentialing17102796__credentialing
decertifying2292796_de__certifying
densifying1844816_____densifying
desertifying2092876_de__sertifying
objectifying3051696o___bjectifying
orientating1245776o__ri_ent_ating
orienteering1352616o__ri_enteering
orienting1038726o__ri_ent___ing
overbeating17410486over_beat___ing
overbetting1747456over_be_t__ting
overbreathing22173676overbreat__hing
overcounting1846616overcount___ing
overdecking2246056over_de___cking
overdecorating2153686over_decorating
overdemanding2152796over_de_manding
overdeveloping2461786over_developing
overdirecting2053746overdirect___ing
overdrinking2143976over_d__rinking
overdriving1946096over_d__ri_ving
overdrying1846546over_d____rying
overeating141016536over__eat___ing
overediting1648046over__e_di_ting
overestimating2054326over__estimating
overexciting2565336over__exci_ting
overexercising2782586overexerci_sing
overexerting2346496overexert___ing
overextending2553916over__extending
overfertilizing31101826over_fertilizing
overheating1849936over_heat___ing
overhunting1856526over_hunt___ing
overindulging1952256overi__ndulging
overinflating2053966overi__nflating
overinforming2252856overi__nforming
overlending1647616over_len___ding
overlengthening2371396over_lengthening
overletting1548016over_le_t__ting
overmelting1768116over_melt___ing
overplanting1846976overplant___ing
overprinting1846876overprint___ing
overservicing2252736over_servi_cing
oversetting1548816over_se_t__ting
overspending1945736overspen___ding
overstaffing2243656over___staffing
overstaying1847056over___st_aying
overstirring1644536over___stirring
overstudying2043176over___studying
overstuffing2253056over___stuffing
oversweetening2171866oversweet_ening
overtiming1699076over____ti_ming
overtipping1945236over____tipping
overtiring141210206over____ti_ring
overtreating1648556overtreat___ing
overwearying2244106over_we__arying
overweening1846236overween____ing
overweighing2353706over_we__ighing
overwetting1847256over_we_t__ting
overwintering2053056over_wint_ering
personifying2152376_per_son_ifying
prenotifying2153056__pr__enotifying
presignifying2351796presi_gn_ifying
prettifying2044006__pr__ettifying
recertifying2183236___recertifying
rectifying1946376___r__ectifying
reidentified1762936_re_identif_ied
reidentifies1663226_re_identif_ies
reidentify1753136_re_identify___
renotifying1844186___r__enotifying
resinifying1844356_resi__n_ifying
retestifying1993416___retestifying
verbifying2244356_ver____bifying
verifying1936416_ver_____ifying
versifying2045036_ver____sifying
vinifying1944716_v__i__n_ifying

Search took 8 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 Limit95024877.06313453.8
3Display Results87870.0631381.0
 (SQL Overall)178691877.48623870.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.