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

135 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
solarise851254(None) 
polarise10513901polarise
solarised1068041solarised
solarises9512701solarises
solarism10810381solarism
solarize17511471solarize
polarised1269232polarised
polarises11514072polarises
polarize19512652polarize
salaries8319572salaries
solanine8311532solanine
solaria7312492solari_a
solarisms1168812solarisms
solarium1078262solarium
solarized1969152solarized
solarizes18511612solarizes
solecise1089072solecise
souaris7312332souaris_
arise56436433___arise
boarish123911913bo_arish
botanise1039643botanise
boyarism1546393boyarism
claries93422203_claries
coarse84813903co_ar_se
colonise102514283colonise
colorism122112433colorism
colorist102818993colorist
colorize192314203colorize
comprise14310813comprise
covaries13413253covaries
dolerite9611773dolerite
dollarize1946193dollarize
filariae1148473filariae
focalise131210373focalise
hoarse94411323ho_ar_se
holards1148433holards_
isobarism1343833isobarism
larine63927043__larine
laris54737463__laris_
localise101511853localise
malaise9312673mala_ise
molarity13118903molarity
molars85517323molar_s_
moonrise1046783moonrise
moralise10314913moralise
motorise10311523motorise
notaries8314933notaries
notarize1749293notarize
ovaries10312653_ovaries
polarity131310403polarity
polarized21610283polarized
polarizer2079173polarizer
polarizes20513023polarizes
polars84419353polar_s_
popularise1445423popularise
rolamite1048743rolamite
romanise10312133romanise
rosaries8312783rosaries
rotaries8315693rotaries
safaris101110663safaris_
salamis9313513salamis_
salariat8416303salariat
salaried9311023salaried
saris54544953s__aris_
satirise8310683satirise
scariose1037593s_cariose
sclerite10410713sclerite
sclerose1046223sclerose
secularise12146593secularise
sitarist8315283sitarist
slavish1338233s_lavish
soaring83521893so_aring
soars54732513so_ar_s_
soberize1998883soberize
socialise1148733socialise
sodalist9311883sodalist
sodalite9109593sodalite
sodamide1245453sodamide
sofars94712783sofar_s_
solace83415823sola__ce
solaces93116133solaces_
solacing11310133solacing
solands84412343solands_
solanin7311943solani_n
solanines9310083solanines
solanins8310513solanins
solanos74412853solanos_
solans64122493sola_ns_
solar55927343solar___
solarising1147053solarising
solariums1165923solariums
solate64526073sola__te
solates73523853solates_
solatia7312253solati_a
solating9315593solating
solation8916153solation
solatium1067613solatium
solecised1285873solecised
solecises1189103solecises
solecism12107593solecism
solecist10910783solecist
solecize1998383solecize
solidarism1354273solidarism
solidarist1156183solidarist
solitaries10410123solitaries
soloist7915893sol_oist
solstice1047223solstice
somewise1345553somewise
sonars64818973sonar_s_
sonatine8313323sonatine
souari6311383souari__
soubise9118793so_ubise
sourish10310693so_urish
sowars94318013sowar_s_
sparse84516343s_par_se
squarish2047323squarish
stearine8311903stearine
suberise10813933suberise
sudaries9312753sudaries
summarise13115733summarise
sunrise7310813s_unrise
surprise1037673surprise
sybarite1396543sybarite
tolars64817943tolar_s_
totalise8312503totalise
tovarish1445123tovarish
valorise112110303valorise
velarize2048763velarize
vocalise131510813vocalise
volatile1146433volatile
voleries11313233voleries
votaries11312013votaries
votarist111012163votarist
vulgarise13495993vulgarise
womanise1348733womanise

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621357.51619446.8
3Display Results1351350.0632142.9
 (SQL Overall)1786911358.03222247.4
 
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.