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

109 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
solunar73528(None) 
columnar1243712columnar
lunar57017312__lunar
solar55927342sol__ar
sonar56523422so__nar
soucar839322so_ucar
sublunar1044102sublunar
alular6311353_alular
bolar75123473bol__ar
bolivar1244853bolivar
cislunar1082023cislunar
colinear1045913colinear
collar83816173col_lar
columnal1244413columnal
coplanar1244473coplanar
copular113810603copular
cougar958783co_ugar
dollar74110983dol_lar
foliar93210973fol_iar
jocular1637303jocular
koruna1035483koruna_
korunas1135443korunas
lacunar9136293lacunar
lobular936663lobular
locular938953locular
luna46229853__luna_
lunars65012813__lunars
lunas55025013__lunas
modular1087363modular
molar75223093mol__ar
morular978223morular
nodular876703nodular
nounal639813no_unal
ocular8610133_ocular
oscular937933oscular
ovular946833_ovular
pilular938203pilular
planar84212713_planar
polar75623453pol__ar
popular11319563popular
salina64221123salina_
salinas73116093salinas
salutary1145113salutary
saluter73512453saluter
sauna54117553s_auna_
saunas63915433s_aunas
secular92211533secular
semilunar1153493semilunar
seminar979753seminar
shogunal1242383shogunal
simular938673simular
slung65117833s_lun_g
slunk95016303s_lun_k
slur45525153s_lu__r
soar46838673so___ar
sofar86115493so__far
sola45541863sol__a_
solacer93011103solacer
solan55328153sol__an
soland75115043solan_d
solander948123solander
solands84412343solands
solanin7311943solanin
solano65314183solan_o
solanos74412853solanos
solans64122493solan_s
solanum946403solanum
soldan73511853sol_dan
soldans83210403soldans
solder73921343sol_der
soldier82812153soldier
solemner1045053solemner
solidary1245103solidary
solider82912453solider
soling74226823solin_g
solitary1146503solitary
solon55026133solon__
solons65120023solon_s
soluble966103soluble
solubly1255283solubly
solum74717613solu__m
solums85211333solu_ms
solus54726983solu__s
solute64016663solu_te
solutes73515263solutes
solver94016703sol_ver
sonars64818973so__nars
sooner64220463so_oner
sorner64720393so_rner
souari6311383so_u_ari
soucars938423so_ucars
soudan73210353so_udan
sound64420023so_un_d
sounder83315383so_under
sounds74616183so_unds
sour45935893so_u__r
sourer63620213so_urer
souter64225923so_uter
sowar85821343so__war
sowcar1135863so_wcar
sporular1065223sporular
sublunary1442883sublunary
sugar6312913s__ugar
tolar55524113tol__ar
tollbar945453tollbar
ulnar56013983_ul_nar
volar86917413vol__ar
voluntary1543003voluntary
zonular1656493zonular

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.1601116818.8
2DLD Change Limit1340271097.25018486.5
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.45623966.1
 
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.