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

32 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
jaundices194218(None) 
jaundice1842011jaundice_
jaundiced2041191jaundiced
caudices13337342cau_dices
jaunces16307422jaun__ces
maundies1137852maundi_es
audiles83112613_au_diles
aunties73920073_aunti_es
auspices1236443_auspices
bandies104124863ba_ndi_es
caddices14297853ca_ddices
candies104125613ca_ndi_es
dandies94121443da_ndi_es
gaudies9311973gau_di_es
indices103513443__indices
jaunce15367433jaun__ce_
jaunced17335473jaun__ced
jaundicing2141483jaundicing
jauntier1535233jaunti_er
jauntiest1635493jaunti_est
jauntiness1743973jauntiness
jounces16369853joun__ces
juices1549423j_u__ices
junkies183711693j_unki_es
justices1737523j_ustices
launces9329003laun__ces
laundries1045563laundries
pandies104224503pa_ndi_es
radices102314263ra__dices
randies84225663ra_ndi_es
undies73821963__undi_es
undines8716083__undines

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 Filter1786911486410.640279204.7
2DLD Change Limit148641327.29620372.9
3Display Results32320.0162000.0
 (SQL Overall)178691327.95222471.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.