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

69 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
tantalizes1910994(None) 
tantalises101010101tantalises
tantalites1099281tantalites
tantalize181010571tantalize_
tantalized20118921tantalized
tantalizer19107281tantalizer
tantalizers2084261tantalizers
banalizes201210092ban_alizes
canalizes201113782can_alizes
fantasizes2295462fantasizes
tantalates10106702tantalates
tantalise91210822tantalise_
tantalised11126982tantalised
tantalite91010862tantalite_
tantaluses10104592tantaluses
totalizes18311052t_otalizes
vandalizes2346462vandalizes
actualizes2145903_actualizes
alkalizes22157353_alkalizes
analyzes20157193_an_alyzes
animalizes2148203_animalizes
annualizes1945083annualizes
banalize191010933ban_alize_
banalized21118703ban_alized
brutalizes2175603brutalizes
canalises11515493can_alises
canalize19914493can_alize_
canalized21611693can_alized
cantabiles1445763cantabiles
capitalizes2466913capitalizes
cartelizes2147633cartelizes
catalyzes2346053ca_talyzes
centralizes2249423centralizes
fantasies1298853fantasi_es
fantasises1395883fantasises
fantasize2196053fantasize_
fantasized2385123fantasized
fantasizer2294163fantasizer
fantasizers2392883fantasizers
finalizes212810743fin_alizes
gantlines1039333gant_lines
labializes2145793labializes
metalizes20414243_metalizes
nasalizes1847233na_salizes
palatalizes2244863palatalizes
pantalones1246723pantalones
penalizes20911853pen_alizes
racializes2148463racializes
sacralizes2148233sacralizes
scandalizes2344533scandalizes
tantalate9107373tantalate_
tantalic1048053tantali__c
tantalizing2158073tantalizing
tantalous946193tantal_ous
tantalums1143103tantal_ums
tantalus836373tantal__us
tantivies1247103tantivi_es
tanzanites1944003tanzanites
tentatives1345483tentatives
tetanizes1889843t_etanizes
totalises9311783t_otalises
totalize17311523t_otalize_
totalized1949453t_otalized
totalizer1847993t_otalizer
totalizers1944963t_otalizers
vandalises1446813vandalises
vandalize2246793vandalize_
vandalized2445813vandalized
vitalizes2139923_vitalizes

Search took 7 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 Limit140603695.98623488.6
3Display Results69690.0302300.0
 (SQL Overall)178691696.42227824.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.