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

177 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
solaria731249(None) 
solatia7312251solatia
filaria1039652filaria
malaria9313692malaria
rosaria749252rosaria
salariat8416302salariat
sharia93116732s_haria
solanin7311942solanin
solar55927342solar__
solarise8512542solarise
solarism10810382solarism
solarium1078262solarium
solarize17511472solarize
souari6311382souari_
souaris7312332souaris
sudaria847972sudaria
talaria7412512talaria
velaria1038922velaria
zoaria1548382zo_aria
adularia945053adularia
angaria8311583angaria
aplasia92510803aplasia
aquaria1638043aquaria
aria46245423___aria
bolar75123473bolar__
bolivia1246063bolivia
bothria1246443bothria
calcaria1249533calcaria
caldaria1148953caldaria
calvaria1347893calvaria
clarkia1334873_clarkia
collyria1344823collyria
coria75828323co__ria
deliria868303deliria
filariae1148473filariae
filarial1147863filarial
filarian1148313filarian
folacin1238053folacin
folia83618933fol__ia
fusaria1046223fusaria
galabia1038323galabia
gloria71910543_gloria
holard10410573holar_d
holards1148433holards
isobaric1244753isobaric
labia75219013__labia
lamia75324323__lamia
lari45839153__lari_
lariat6629043__lariat
laris54737463__laris
larva8312483__larva
latria62313593__latria
logania847833logania
malarial10410613malarial
malarian10311563malarian
malarias10313773malarias
maria75032883__maria
miliaria1048783miliaria
mojarra1642513mojarra
molar75223093molar__
molarity13118903molarity
molars85517323molar_s
monarda1046613monarda
noria55722183no__ria
notarial8410753notarial
ocarina948033_ocarina
ovarial1037613_ovarial
ovarian1037643_ovarian
peloria9310953peloria
polar75623453polar__
polarise10513903polarise
polarity131310403polarity
polarize19512653polarize
polaron939843polaron
polars84419353polar_s
polyparia1645793polyparia
polyuria1355823polyuria
puparia1147353puparia
rosarian847593rosarian
sacraria1047393sacraria
safari91110223safari_
safaris101110663safaris
salami8313103salami_
salamis9313513salamis
salariats947823salariats
salaried9311023salaried
salaries8319573salaries
salary9515213salar_y
salvia93310753sal_via
samara8313853samar_a
sangria838113sangria
sari45444043s__ari_
sarin55239253s__arin
saris54544953s__aris
satara6315533satar_a
savarin10310003savarin
sclera838893scler_a
scoria8513503s_coria
sedarim1047113sedarim
senarii7269143senarii
septaria1047413septaria
shariah132210533s_hariah
sharias102516003s_harias
sharif122917123s_harif
silesia739083silesia
silurian846293silurian
silurid837013silurid
slain54923573s_la_in
soar46838673so_ar__
soared74324293so_ared
soarer64522243so_arer
soaring83521893so_aring
soars54732513so_ar_s
sofar86115493sofar__
sofars94712783sofar_s
sola45541863sol___a
solace83415823sola_ce
solaced102911063solaced
solacer93011103solacer
solaces93116133solaces
solacing11310133solacing
solan55328153sola__n
soland75115043sola_nd
solands84412343solands
solanine8311533solanine
solanins8310513solanins
solano65314183sola_no
solanos74412853solanos
solans64122493sola_ns
solanum946403solanum
solarised1068043solarised
solarises9512703solarises
solarisms1168813solarisms
solariums1165923solariums
solarized1969153solarized
solarizes18511613solarizes
solate64526073sola_te
solated83618023solated
solates73523853solates
solating9315593solating
solation8916153solation
solatium1067613solatium
soldi65717203sol_di_
solei55624343sol_ei_
soleret7321233soleret
soli46637013sol__i_
solicit9315743solicit
solid65025083sol__id
solidi73813153solidi_
somata8312383soma_ta
somatic111916463somatic
sonar56523423sonar__
sonarman1045563sonarman
sonars64818973sonar_s
sonata6313223sona_ta
sonatina849073sonatina
sora45746913so__r_a
sori46039843so__ri_
sorta57125413so__rta
souvlakia1651043souvlakia
sowar85821343sowar__
sowars94318013sowar_s
sparid94016933s_parid
splenia948313splenia
stadia7312143s_tadia
stearic939423stearic
stearin7312003stearin
stria55723213s__tria
subarea939403subarea
subarid10310653subarid
tilapia945553tilapia
tolar55524113tolar__
tolars64817943tolar_s
varia85824203__varia
vivaria1346983vivaria
volar86917413volar__
zoarial1646923zo_arial

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271777.01619103.1
3Display Results1771770.0632809.5
 (SQL Overall)1786911777.48223882.8
 
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.