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

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

44 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
bastardized246240(None) 
bastardised1572281bastardised
bastardize2263091bastardize_
bastardizes2392861bastardizes
bastardies1365142bastardi_es
bastardise1383562bastardise_
bastardises1473482bastardises
bacterized2446283bacter_ized
barbarized2444853barbar_ized
bastardizing2552763bastardizing
abstained1245054absta__ined
bacterize2247654bacter_ize_
bacterizes2347964bacter_izes
balkanized2643804balka_nized
banalized21118704ba_na_lized
baptized2245484bapt___ized
barbarize2246244barbar_ize_
barbarizes2345874barbar_izes
bastard103012424bastar____d
bastardising1652204bastardising
bastardly15264294bastard__ly
bastards113310314bastard___s
bastardy14326004bastard___y
bestialized2346044bestialized
botanized2147284b_ota_nized
brutalized2275074bruta_lized
cauterized2286314cauter_ized
factorized2595554factor_ized
fantasized2385124fanta_sized
faradized23216314fa_ra_dized
jeopardized3191944jeopardized
laterized1979904la_ter_ized
martyrized2543534martyr_ized
nasalized1946754nas_a_lized
notarized1947154_notar_ized
ostracized2254034_ostracized
pasteurized2353114pasteurized
sardined10268664__s_ardined
satirized1957894sa_tir_ized
standardized24222404standardized
stargazed2043074__stargazed
sturdied10215964__sturdi_ed
tantalized20118924tanta_lized
westernized2453524westernized

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 Filter1786911488190.1561145455.1
2DLD Change Limit148819449.09316366.3
3Display Results44440.0162750.0
 (SQL Overall)178691449.26519286.7
 
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.