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

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

106 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
overgeneralized29163151overgeneralized_
overgeneralize27193442overgeneralize__
overgeneralizes28183172overgeneralize_s
overcentralized30133773overcentralized_
overcentralize28114244overcentralize__
overcentralizes29123884overcentralize_s
generalized22147445____generalized_
overidealized2753875over_ide_alized_
decentralized26144596_de_centralized_
demineralized2694076_de_mineralized_
generalised13185686____generalised_
generalize20198456____generalize__
generalizer21156266____generalize_r
generalizers22194086____generalizers
generalizes21178276____generalize_s
orientalized2264996o__rien_talized_
outgeneraled1461166o_utgeneral__ed_
overanalyzed28123086over_an__alyzed_
overcapitalized3272556overcapitalized_
overdetermined2162456overdeter_mined_
overemphasized3463526over_emphasized_
overenrolled1652996over_en_rol_led_
overentertained1972046over_entertained_
overexercised2663316over_exer_cised_
overfertilized3063046overfe_rtilized_
overgenerosity2171646overgenerosi__ty
overgrazed2466006overg___ra__zed_
overidealize2554426over_ide_alize__
overidealizes2654016over_ide_alize_s
overspecialized3272566overspecialized_
vernalized2348426_ver__n__alized_
adrenalized2253507_adr_en__alized_
centralized2348157____centralized_
decentralize2455407_de_centralize__
decentralizes2575147_de_centralize_s
degeneracies1653557_de_generaci_e_s
degenerated1445747_de_genera__ted_
degenerative1754967_de_generative__
demineralize2484867_de_mineralize__
demineralizer2593587_de_mineralize_r
demineralizers26102197_de_mineralizers
demineralizes25104447_de_mineralize_s
essentialized2363267__essentialized_
eternalized21117337eter__n__alized_
etherealized2553357__ethere_alized_
federalized2545147____federalized_
generalise11178127____generalise__
generalises12167827____generalise_s
generalizing2346357____generalizing
governmentalize30123087governmen_talize__
marginalized2563187_margin__alized_
mineralized2346657____mineralized_
occidentalized2962087occiden_talized_
orientalize2065987o__rien_talize__
orientalizes2175757o__rien_talize_s
outgeneraling1561287o_utgenerali__ng
overadvertised2262207overadver_tised_
overanalyze26143237over_an__alyze__
overanalyzes27123387over_an__alyze_s
overbejeweled296797overbejewel__ed_
overcapitalize3072707overcapitalize__
overcapitalizes3182557overcapitalize_s
overcivilized3162907over__civilized_
overcontrolled2091597overcontrol_led_
overdecorated2053447overdecora__ted_
overdeveloped2382007overdeve__loped_
overdramatized30162597over_dramatized_
overemphasize3263807over_emphasize__
overemphasizes3363697over_emphasize_s
overenamored1852687over_en__amored_
overexercise2463697over_exer_cise__
overexercises2563437over_exer_cise_s
overexerted2245277over_exer___ted_
overexplained2683787over_expla_ined_
overfertilize2883307overfe_rtilize__
overfertilizes2973107overfe_rtilize_s
overgenerous1662267overgener____ous
overgenerously2171537overgener__ously
overglamorized3071937overg_lamorized_
overglazed2475417overg_____lazed_
overgoverned2052237overgover___ned_
overgraded1656597overg___ra__ded_
overgraze2276677overg___ra__ze__
overgrazes2356287overg___ra__ze_s
overidealizing2863457over_ide_alizing
overoperated1876047over_opera__ted_
overorganized2763317over__organized_
overpedaled1844307over__pedal__ed_
overpedalled1953027over__pedal_led_
overpraised1746217over___pra_ised_
overprized2587637over___pr__ized_
overserviced2193127over__ser_viced_
overspecialize3062817overspecialize__
overspecializes3172557overspecialize_s
overstrained1645277over__stra_ined_
overtrained1547107over___tra_ined_
overutilized2554317over___utilized_
overwearied1845767over__we_ari_ed_
personalized2455877_person__alized_
reenergized2252557___reener_gized_
regeneracies1553747_re_generaci_e_s
regenerated1346907_re_genera__ted_
regenerative1655307_re_generative__
verbalized2547617_ver____balized_
vernalize2159847_ver__n__alize__
vernalizes2249327_ver__n__alize_s

Search took 9 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.1231452772.4
2DLD Change Limit950241068.01611854.3
3Display Results1061060.0801325.0
 (SQL Overall)1786911068.21921741.2
 
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.