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 “patinizes” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
patinizes2071033(None) 
latinizes18610151latinizes
patinize19610771patinize_
patinized2178811patinized
platinizes2147791platinizes
cutinizes2047872cutinizes
latinize17610562latinize_
latinized1988522latinized
paganizes2148662paganizes
patinates113814692patinates
patines95225762patin__es
patronizes2187392patronizes
platinize2068102platinize_
platinized2246902platinized
salinizes1839142salinizes
satirizes1849382satirizes
actinides12188323actinides
activizes2346323activizes
agenizes18269743_agenizes
agnizes17328843_a_gnizes
agonizes182610583_agonizes
atomizes192711423_atomizes
atonies75320953_atoni_es
atticizes2047663atticizes
avianizes2145553_avianizes
botanizes2048413botanizes
canonizes2049593canonizes
caponizes2238703caponizes
cotinines11410073cotinines
cutinises1148513cutinises
cutinize1948523cutinize_
cutinized2146903cutinized
deaminizes2246803deaminizes
divinizes2266673divinizes
feminizes23238523feminizes
gelatinizes2144833gelatinizes
hominizes2358273hominizes
japanizes2745163japanizes
kainites1238793ka_inites
keratinizes24104803keratinizes
laicizes1937403la_icizes
laterizes18513013laterizes
latinities10410153latinities
luteinizes1943883luteinizes
matinees102110423matin_ees
matronizes2196813matronizes
maximizes2944403maximizes
mutinies10311503mutini_es
optimizes2245413optimizes
pacifies15311223pacifi_es
paganises1239723paganises
paganize2048633paganize_
paganized2247163paganized
paganizer2145763paganizer
paganizers2253713paganizers
paginates123111363paginates
painches1588913pa_inches
palinodes1245883palinodes
parities10522973pariti_es
partitives1546623partitives
patencies1349173patencies
patentees1196543patentees
patiences1367433patiences
patinae95414403patin_ae_
patinaed11407833patin_aed
patinas96318523patin__as
patinate103016313patinate_
patinated123911413patinated
patine85328123patin__e_
patined105114783patin__ed
patining11312303patini_ng
patinizing2248603patinizing
patins87528783patin___s
patricides1546283patricides
patronises1298433patronises
patronize2077193patronize_
patronized2276063patronized
patsies93919483pat_si_es
patties93425143pat_ti_es
peptonizes2346403peptonizes
petuntzes2042143petuntzes
pidginizes2342893pidginizes
pinites9319533p__inites
plasticizes2495653plasticizes
poeticizes2347123poeticizes
pollinizes2146953pollinizes
ratanies8312923ratani_es
raticides1248693raticides
ratifies11313513ratifi_es
ratines75328583ratin__es
retinites9313493retinites
routinizes1946013routinizes
salinize1739683salinize_
salinized1947373salinized
sanitizes181210133sanitizes
satirises9410193satirises
satirize1749693satirize_
satirized1957883satirized
satirizer1846453satirizer
satirizers1943953satirizers
tetanizes1889833tetanizes
utilizes1758113_utilizes
vaticides1546603vaticides

Search took 9 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 Limit1486411037.83018983.5
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.07922118.0
 
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.