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

176 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
palatines1131303(None) 
palatine10316061palatine_
alanines8314802_alanines
calamines13312222calamines
galantines1145732galantines
gelatines102910532gelatines
paladins11911002paladin_s
palates93624932palat__es
palatinates1344992palatinates
patines95225762p__atines
platanes102711882p_latanes
platies93722542p_lati_es
platinas103610312p_latinas
platings113611362p_latings
saltines82917792sal_tines
abatises10311013_abatises
ablatives1445503ablatives
acarines10314343_acarines
agatizes1838863_agatizes
alanine7316863_alanine_
alanins7315803_alanin_s
alates64833963_alat__es
alations82518893_alations
alexines15258503_alexines
alines65735223_al__ines
alkines114415733_al_kines
alpines94016193_al_pines
alumines10411683_alumines
apatites10311293_apatites
astatines9310343astatines
balklines1536743balklines
calamine12314033calamine_
calamined1447433calamined
calamints1348053calamints
calamites13410713calamites
calcines12314753cal_cines
calmatives1744733calmatives
carabines13311473carabines
cavatinas1444783cavatinas
cavatine13310323cavatine_
creatines112814433creatines
delaines9312963dela_ines
eglantines1143673eglantines
elatives1139783_elatives
flamines13311643_flamines
flatlines12268433_flatlines
flavines1437893_flavines
galantine1047323galantine_
galaxies1637163galaxi_es
gallamines1345493gallamines
gelatine93213303gelatine_
gelatins93414093gelatin_s
halations12312393halations
halazones2145993halazones
halftimes1742883halftimes
halftones1545213halftones
hematines141312203hematines
illatives1245523illatives
isatines8310663_isatines
jalapins1745623jalapin_s
latices9313763__latices
latinas74416463__latinas
latinos73613803__latinos
latrines8515003__latrines
lawines103313563__lawines
laxatives1943353laxatives
magazines2145633magazines
maladies11311933maladi_es
malaises10312333mala_ises
malates93522603malat__es
malines93625603mal__ines
maltiness112910573mal_tiness
melamines1339763melamines
opalines10311423opal__ines
paganises1239723paganises
paganizes2148663paganizes
paintings12327093paintings
palaces114216453pala__ces
paladin101011773paladin__
palais8420423pala_i__s
palatalizes2244843palatalizes
palatals1037773palat_als
palate84226783palat__e_
palatial10410623palati_al
palatialness1453233palatialness
palatinate1245593palatinate
palettes103112833palet_tes
palings103915823pal__ings
palletises1247223palletises
palletizes2176443palletizes
palliatives1643513palliatives
palmations1438733palmations
palmitins1346953palmitin_s
palominos1344063palominos
palpates122613063palpat__es
palpating1438543palpatin_g
palpations1437653palpations
palsies94420273pal_si_es
paltriness1244993paltriness
panties94230933pa_nti_es
pantiles103617153pa_ntiles
papacies1439483papaci_es
papains11312363papa_in_s
paradises122513203paradises
paraffines1844323paraffines
parakites1549543parakites
parasites11313153parasites
parataxes1846393parataxes
paravanes1448303paravanes
parawings1535823parawings
parities10522973pariti_es
parties93230863pa_rti_es
partings113513733pa_rtings
pasties94529813pa_sti_es
pastimes123611903pa_stimes
pastinas103712153pa_stinas
pastiness112312353pa_stiness
pastises103616053pa_stises
patinas96318523p__atinas
patine85328123p__atine_
patined105114783p__atined
patins87528783p__atin_s
patties93425143pa_tti_es
pavanes123612653pava__nes
pectines121914683p_ectines
pelerines11311843pelerines
pilotings1234353pilotings
plaices11411143p_la_ices
plained103812233p_la_ined
plainer93811983p_la_iner
plainest10313613p_la_inest
plains85019593p_la_in_s
plaints94012053p_la_ints
plaitings12296243plaitings
planes85028083p_la__nes
plantings12348403plantings
platane93112303p_latane_
platans93413123p_latan_s
platens94213983p_laten_s
plates85432243p_lat__es
platier93716293p_lati_er
platiest103216093p_lati_est
platina94413643p_latin_a
plating103823073p_latin_g
platinic1237073p_latinic
platinizes2147793p_latinizes
platinous1146193p_latinous
platinum1245443p_latinum
platinums1343963p_latinums
playtimes1644413playtimes
plotlines1146823p_lotlines
polarises11514073polarises
polarizes20513023polarizes
polities102722343politi_es
polyamines1746583polyamines
poutines102415103p_outines
pralines102217723p_ralines
prolamines14159363prolamines
ratines75328583__ratines
relatives1239963relatives
salaries8319583salari_es
salicines11310003salicines
salines74029413sal__ines
salties73725773sal_ti_es
saltine75018563sal_tine_
saltiness93312113sal_tiness
saltings92811253sal_tings
saltires83112423sal_tires
slatiness92511363_slatiness
slatings94011723_slatings
smaltines1136993smal_tines
solanines9310083solanines
valentines1344953valentines
valines104520213val__ines
volatiles1246133volatiles
zaratites1847003zaratites

Search took 7 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 Limit1486411766.32623496.8
3Display Results1761760.0931892.5
 (SQL Overall)1786911766.85526067.3
 
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.