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

57 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
uintaites913633(None) 
uintahites13122791uintahites
uintaite8127351uintaite_
uintahite12113142uintahite_
biotites10310093biot_ites
cineastes1165563cineastes
dictates11311383dicta_tes
distastes1039633distastes
finites10315923fin__ites
incites93218483_in_cites
indites83618983_in_dites
infantes11249633_infantes
ingates82716913_inga_tes
initiates9411183_initiates
inmates92715783_inma_tes
inosites8312793_inosites
instates81615833_insta_tes
intakes11310943_inta_kes
intines7921113_int_ines
intitles8710003_int_itles
intuited938763_intuited
intuits7310313_intuit_s
intwines1138043_intwines
invites103915813_in_vites
lintwhites1651533lintwhites
mintages111110513minta_ges
nictates1039593nicta_tes
nitrites82313453ni_trites
pinites9319533pin__ites
pintadoes1295253pintadoes
pintailed1245553pintailed
pintails10310163pintai_ls
quintains18306033quintai_ns
quintettes1943003quintettes
quintiles1845983quint_iles
ruinates8311883ruin_a_tes
sinuates8310963sinua_tes
tantalites1099283tantalites
titanites997413ti_tanites
unakites1237543u_nakites
unfaiths1443213u_nfaiths
uninitiates1164003uninitiates
unitages938273unita_ges
unites65024853u_n__ites
unities72520153unit_i_es
unitizes1739133unit_izes
unstates81314993unsta_tes
untainted1038423u_ntainted
untasted92011573u_ntasted
unties64326923u_nt_i_es
untwines1137603u_ntwines
upstates10189643upsta_tes
urinates8314133urin_a_tes
vintages12118273vinta_ges
vitiates112311433vi_tiates
zincates1937743zinca_tes
zincites1946633zin_cites

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.436409841.7
2DLD Change Limit148641576.92321470.6
3Display Results57570.0301900.0
 (SQL Overall)178691577.38924183.4
 
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.