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

118 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
solarises951270(None) 
polarises11514071polarises
solarise8512541solarise_
solarised1068041solarised
solarisms1168811solarisms
solarizes18511611solarizes
polarise10513902polarise_
polarised1269232polarised
polarizes20513022polarizes
salaries8319572salari_es
solanines9310082solanines
solarism10810382solaris_m
solariums1165922solariums
solarize17511472solarize_
solarized1969152solarized
solecises1189102solecises
arises65233803___arises
bolases93315003bola__ses
botanises1139163botanises
boyarisms1645443boyarisms
claries93422203_clari_es
colitises11311743colitises
colonises112814013colonises
colorisms132810793colorisms
colorists112313593colorists
colorizes203014523colorizes
comprises15510943comprises
covaries13413253covari_es
dolerites101410893dolerites
dollarizes2046043dollarizes
filariases1343983filariases
focalises14139953focalises
glacises1138503_glacises
isobarisms1443093isobarisms
lapises93513463__lapises
localises111411463localises
lorises73918593__lorises
malaises10312333mala_ises
molarities12129433molarities
molasses1037233mola_sses
moonrises1146723moonrises
moralises11314003moralises
morrises10711073mo_rrises
motorises11311673motorises
noncrises11129313noncrises
notaries8314933notari_es
notarizes1848713notarizes
orrises71312233_o_rrises
ovaries10312653_ovari_es
oxalises1538503_oxalises
parises94827183__parises
polarities121211773polarities
polarize19512653polarize_
polarized21610283polarized
polarizer2079173polarizer
polarizers2165893polarizers
popularises1555153popularises
rolamites1148243rolamites
romanises11311573romanises
rosaries8312783rosari_es
rotaries8315693rotari_es
salariats947823salariats
salaried9311023salari_ed
saroses73619333s__aroses
satirises9410193satirises
sclerites1139443sclerites
scleroses1146373scleroses
secularises13155873secularises
sherrises12156863sherrises
sitarists949373sitarists
soarings93210393so_arings
soberizes2098963soberizes
socialises1258253socialises
sodalists1038153sodalists
sodalites10128693sodalites
sodamides1344653sodamides
solaces93116133sola__ces
solanine8311533solanine_
solanins8310513solani_ns
solaria7312493solari__a
solarising1147053solarising
solarium1078263solari_um
solates73523853sola__tes
solations9814623solations
solecise1089073solecise_
solecised1285873solecised
solecisms1396703solecisms
solecists1187073solecists
solecizes2087863solecizes
soleuses838073sol_euses
solidarisms1453503solidarisms
solidarists1253923solidarists
solitaries10410123solitari_es
soloists869153sol_oists
solstices1146703solstices
sorites73825243so__rites
soroses73117483so__roses
sorosises947303sorosises
souaris7312333souari__s
soubises10107993so_ubises
stearines9311283stearines
suberises11813453suberises
sudaries9312753sudari_es
summarises14115253summarises
sunrises8310693s_unrises
surprises1137433surprises
sybarites1465933sybarites
totalises9311783totalises
tovarishes1643353tovarishes
valorises122210183valorises
velarizes2148643velarizes
vocalises141710333vocalises
volatiles1246133volatiles
voleries11313233voleri_es
votaries11312013votari_es
votarists1298603votarists
vulgarises14135493vulgarises
womanises1448063womanises

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411187.00321225.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.46923924.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.