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

163 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
solatia731225(None) 
solaria7312491solaria
solanin7311942solanin
solate64526072solat_e
solated83618022solated
solates73523852solates
solating9315592solating
solation8916152solation
solatium1067612solatium
somata8312382somat_a
somatic111916472somatic
sonata6313222sonat_a
sonatina849072sonatina
aplasia92510803aplasia
balata8614683balat_a
boleti8413403boleti_
bolivia1246063bolivia
coati75624643co_ati_
coatis85122603co_atis
colitic112916193colitic
colitis92617353colitis
comatic131816943comatic
comatik15139723comatik
comitia1139723comitia
cymatia1446443cymatia
filaria1039653filaria
folacin1238053folacin
folate93320393folat_e
folates103218453folates
folia83618933fol__ia
galabia1038333galabia
galatea839973galatea
gelati73814533gelati_
gelatin83514733gelatin
gelatis83313513gelatis
godetia945353godetia
himatia1248593himatia
ignatia846133ignatia
isolate7313923isolat_e
isolated9410523isolated
isolates8613513isolates
isolating1039743isolating
isolation9311643isolation
isolator847533isolator
komatik12135203komatik
labia75219013__labia
lamia75324323__lamia
lati46438273__lati_
latina65621143__latina
latria62313603__latria
logania847833logania
malaria9313703malaria
militia949733militia
oolitic92512883oolitic
osmatic11179993osmatic
ostia52315583_o_stia
palatial10410623palatial
platina94413643_platina
politic112918713politic
psoatic1139303pso_atic
rosaria749253rosaria
salami8313103salami_
salamis9313513salamis
salariat8416303salariat
saltie63422433sal_tie
salvia93310753sal_via
sati45539333s__ati_
satin55935223s__atin
satis55633683s__atis
sciatic11910173sciatic
sciatica12106113sciatica
scotia8310803s_cotia
sematic111716883sematic
sharia93116733s_haria
shortia1048193shortia
silesia739083silesia
slain54923573s_la_in
slat46959023s_lat__
slatch114510533s_latch
slate55438283s_lat_e
slated75028313s_lated
slater64429183s_later
slates64934063s_lates
slatey95417063s_latey
slatier74016813s_latier
slating83724653s_lating
slats55436903s_lat_s
slaty86523153s_lat_y
smalti84111193smalti_
softa86415183so_ft_a
softie93312483so_ftie
sola45541863sol___a
solace83415823sola_ce
solaced102911063solaced
solacer93011103solacer
solaces93116133solaces
solacing11310133solacing
solan55328153sola__n
soland75115043sola_nd
solands84412343solands
solanine8311533solanine
solanins8310513solanins
solano65314183sola_no
solanos74412853solanos
solans64122493sola_ns
solanum946403solanum
solar55927343sola__r
solarise8512543solarise
solarism10810383solarism
solarium1078263solarium
solarize17511473solarize
solations9814623solations
soldi65717203sol_di_
solei55624343sol_ei_
solfatara1251433solfatara
soli46637013sol__i_
solicit9315743solicit
solid65025083sol__id
solidi73813153solidi_
soliton7410233soliton
solstice1047223solstice
solute64016663solut_e
solutes73515263solutes
solution889593solution
solvate102710213solvat_e
solvated12237443solvated
solvates11249673solvates
solvating1336443solvating
solvation1237773solvation
somitic111512633somitic
sonantic1048273sonantic
sonatas7510293sonatas
sonatinas945683sonatinas
sonatine8313323sonatine
soritic91414433soritic
sorta57125413so_rt_a
sortie63621993so_rtie
souari6311383souari_
souaris7312333souaris
souvlakia1651043souvlakia
spatial9310323s_patial
splat76129343splat__
splats84817303splat_s
splenia948313splenia
stadia7312143s_tadia
static83118683s_tatic
statin63921473s_tatin
stomata938533stomat_a
stomatic12312003stomatic
strata63616283strat_a
strati63518903strati_
sudaria847973sudaria
sultana7257803sultana
sylvatic1645353sylvatic
talaria7412523talaria
tilapia945553tilapia
velaria1038923velaria
volatile1146433volatile
volta85215623vol_t_a
voltaic1245453voltaic
volti84915963vol_ti_
volutin1098103volutin
zoaria1548383zo_aria

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271637.51617832.2
3Display Results1631630.1231325.2
 (SQL Overall)1786911638.02922255.7
 
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.