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

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

60 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
tantalized2011892(None) 
tantalised11126981tantalised
tantalize181010571tantalize_
tantalizer19107281tantalizer
tantalizes19109941tantalizes
banalized21118702ban_alized
canalized21611692can_alized
fantasized2385122fantasized
tantalise91210822tantalise_
tantalises101010102tantalises
tantalite91010862tantalite_
tantalites1099282tantalites
tantalizers2084262tantalizers
totalized1949452t_otalized
vandalized2445812vandalized
actualized2245343_actualized
alkalized23146603_alkalized
analyzed21155703_an_alyzed
animalized2247013_animalized
annualized2044613annualized
banalize191010933ban_alize_
banalizes201210093ban_alizes
brutalized2275073brutalized
canalised12810913can_alised
canalize19914493can_alize_
canalizes201113783can_alizes
capitalized2556473capitalized
cartelized2246173cartelized
catalyzed2444993ca_talyzed
centralized2348153centralized
fantailed1345563fanta_iled
fantasied1395613fantasi_ed
fantasised14104343fantasised
fantasize2196053fantasize_
fantasizer2294163fantasizer
fantasizes2295463fantasizes
finalized22279243fin_alized
labialized2245403labialized
metalized21412183_metalized
nasalized1946753na_salized
palatalized2354453palatalized
panelized2147033pan_elized
penalized211210243pen_alized
racialized2247683racialized
sacralized2246983sacralized
scandalized2454053scandalized
tantalate9107373tantalate_
tantalates10106703tantalates
tantalic1048053tantali__c
tantalizing2158073tantalizing
tantaluses10104593tantaluses
tetanized1988443t_etanized
totalised1048073t_otalised
totalize17311523t_otalize_
totalizer1847993t_otalizer
totalizes18311053t_otalizes
vandalised1545153vandalised
vandalize2246793vandalize_
vandalizes2346463vandalizes
vitalized2239113_vitalized

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 Filter1786911406030.406440125.6
2DLD Change Limit140603606.95320221.9
3Display Results60600.0134615.4
 (SQL Overall)178691607.37224239.1
 
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.