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

48 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
diffidences215317(None) 
diffidence2053181diffidence_
differences2054912differences
dissidences15164132dissidences
confidences1946633confidences
difference1955023difference_
differenced2153463differenced
diffident1764223diffiden__t
diffidently2252753diffidently
diligences1444333di_ligences
dissidence14134303dissidence_
incidences1547133_incidences
accidences1444404_accidences
affiances1745154_affi_ances
affluences18103354_affluences
coincidences1683524coincidences
confidence1847064confidence_
daffinesses1834844daffinesses
decadences1665144d_ecadences
defences1439634d_ef__ences
deferences1677874d_eferences
defiances1557034d_efi_ances
dependences1745884dependences
desinences1347214d_esinences
diffuseness1852694diffuseness
diligence1344424di_ligence_
dissidents1245024dissiden_ts
divalences16114774di_valences
divergences1874494divergences
dividends15273314di_viden_ds
divulgences1852454divulgences
effluences18103784_effluences
evidences1556334__evidences
faiences1337044__fai_ences
iffinesses1635584_iffinesses
imminences16155064_imminences
impudences1744444_impudences
incidence1447594_incidence_
indifferences2262814indifferences
indigences14227324_indigences
inferences15410344_inferences
influences1545654_influences
miffinesses1944364miffinesses
offences1645024_off__ences
providences1953824providences
residences1368234_residences
stridences1344734_stridences
subsidences1653774subsidences

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.436409841.7
2DLD Change Limit148819488.61017284.4
3Display Results48480.0331454.5
 (SQL Overall)178691489.07919681.8
 
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.