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

66 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
quintains1830603(None) 
quintain17316221quintain_
quintans17337871quinta_ns
quintins17329861quint_ins
maintains1167102maintains
quinins162811292quin__ins
quinolins1844792quinolins
quintals17288002quinta_ls
quintan16399222quinta_n_
quintars17337562quinta_rs
quintas163611712quinta__s
quintics19266982quint_ics
quintin163810332quint_in_
contains10316533_contains
curtains10259703cu_rtains
distains9413603_distains
fountains1245283fountains
maintain1077723maintain_
mountains1146363mountains
muntins92715133mu_nt_ins
pintails10310163_pintails
plantains1147493plantains
qintars16268573q_inta_rs
quantics19276833quant_ics
quanting1849233quant_ing
quartans1736283quarta_ns
quatrains1845583quatrains
quietens17246343quiet_ens
quieting18228463quiet_ing
quillaias1843353quillaias
quillais1745003quillai_s
quilting18218713quilt_ing
quiltings19214683quilt_ings
quinaries1857873quinaries
quinidine19154103quinidine
quinidines20133393quinidines
quinin152811953quin__in_
quinina16278143quin__ina
quininas17286033quin__inas
quinine163011043quin__ine
quinines172410203quin__ines
quinnats17124283quinna_ts
quinoas16337873quinoa__s
quinoids1845693quin_oids
quinolin1744593quinolin_
quinoline1845123quinoline
quinolines1964703quinolines
quinsies1737623quin_sies
quinta153312373quinta___
quintal16389883quinta__l
quintar16478603quinta__r
quintes164114713quint__es
quintets17347203quint_ets
quintic18308883quint_i_c
quintile1736843quint_ile
quintiles1845983quintiles
quints154316563quint___s
quirting18238383quirt_ing
quitting18228833qui_tting
ruinating1039593ruinating
ruinations1039603ruinations
squinting1936223squint_ing
suntans72111733su_nta_ns
sustains838553su_stains
uintaite8127353_uintaite
uintaites9136333_uintaites

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 Filter1786911486410.203880251.2
2DLD Change Limit148641669.31315960.6
3Display Results66660.0302200.0
 (SQL Overall)178691669.54618718.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.