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 “molar” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
molar7522309(None) 
bolar75123471bolar
malar76424441malar
mola66035631mola_
molal75120341molal
molars85517321molars
molas75132091molas
mylar105311531mylar
polar75623451polar
solar55927341solar
tolar55524111tolar
volar86917411volar
alar46340072_alar
boar66134292bo_ar
bola66035562bola_
bolas74733762bolas
boyar106013762boyar
cola66541392cola_
colas75436772colas
collar83816172collar
color76123742color
dollar74110982dollar
dolor67617962dolor
filar84819292filar
foliar93210972foliar
gular6314832gular
hilar85418142hilar
hoar76729162ho_ar
holard10410572holard
jowar155211432jowar
kola85124962kola_
kolas94822232kolas
lar37967532__lar
lobar7313012lobar
maar66025052m_aar
makar115614972makar
malars85020682malars
mar57965942m__ar
medlar93010462medlar
miler75733062miler
moa57249182mo_a_
moan65832012mo_an
moas65545342mo_as
moat66352032mo_at
modal85919232modal
modular1087362modular
mohair1135202mohair
mohur1036512mohur
moiler84017262moiler
moira71012012moira
mol56654592mol__
mold76034332mol_d
molder93819272molder
molds85324832molds
moldy115014652moldy
mole66251832mol_e
moles74747922moles
moll66735702mol_l
mollah11319452mollah
molls75129782molls
molly105222492molly
mols65948572mol_s
molt66356162mol_t
molter84119422molter
molto75619602molto
molts76032092molts
moly96031912mol_y
monad85519472monad
monas74732152monas
moola75117032moola_
moolah11409192moolah
moolas83615592moolas
moor66628552mo_or
moper94925922moper
mor56855002mo__r
mora66641272mora_
morae75831192morae
moral75533432moral
moras76438762moras
moray105423792moray
mortar83812042mortar
morular978222morular
motor75317292motor
mover104220862mover
mower104523452mower
moxa136917742moxa_
moxas145014392moxas
mylars114310442mylars
oar37057952_o_ar
osar46820952_osar
osmolar944482osmolar
pilar75221502pilar
polars84419352polars
poler74431792poler
poplar103611112poplar
roar46328572ro_ar
soar46838672so_ar
sofar86115492sofar
sola45541862sola_
solan55328152solan
sonar56523422sonar
sowar85821342sowar
talar56225382talar
tola45236332tola_
tolan55124012tolan
tolars64817922tolars
tolas54532772tolas
velar85817632velar

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001081.73630990.8
3Display Results1081080.0303600.0
 (SQL Overall)1786911081.85996122.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.