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

174 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
simular93867(None) 
similar937851similar
simulars1047071simulars
fibular12267972fibular
hamular1236972hamular
ligular8348532ligular
pilular938202pilular
secular92211532secular
simar74920812sim__ar
simitar936732simitar
simpler112910862simpler
simulacra1352022simulacra
simulacre1342612simulacre
simulant1048082simulant
simulate10311132simulate
simulator1146712simulator
singular9327562singular
spicular12238902spicular
stipular1045842stipular
titular737522titular
tumular9236542tumular
acicular12218663acicular
alular6311353_alular
angular838533angular
annular737693annular
avicular13237273avicular
bifilar1244043bifilar
biovular1343603biovular
bipolar1145453bipolar
canular9310323canular
cingular11256973cingular
circular1247903circular
copular113810603copular
cupular11317623cupular
dipolar1056853dipolar
fabular12288693fabular
facular122810443facular
fibula11258053fibula_
fibulae12237013fibulae
fibulas12228563fibulas
filar84819293fi__lar
fistular1144253fistular
gular6314833__gular
hilar85418143hi__lar
insular7138703insular
jocular1637303jocular
jugular1534513jugular
ligula7359673ligula_
ligulae8308753ligulae
ligulas8329173ligulas
limuli836343limul_i
limulus935083limulus
lingular9407503lingular
lobular936663lobular
locular938953locular
lunular736013lunular
macular113011943macular
malar76424443__malar
mimbar1297493mim_bar
modular1087363modular
molar75223093__molar
morular978223morular
mutular936643mutular
mylar105311533__mylar
nebular956483nebular
nimbler11358063nimbler
nodular876703nodular
nummular1242693nummular
ocular8610133_ocular
oscular937933oscular
osmolar944483osmolar
ossicular1144083ossicular
ovular946833_ovular
pabular11259473pabular
papular11299763papular
piacular1246573piacular
pilar75221503pi__lar
pillar8314023pi_llar
pinnular1044433pinnular
plumular1243303plumular
popular11319563popular
primula1145713primula_
primulas1246123primulas
radular837833radular
ranular739433ranular
regular838423regular
saccular1246893saccular
sambar103914163sam_bar
sambhar1444853sambhar
samovar1244243samovar
sampler113212013sampler
samurai945923samurai
scalar83612433s_calar
scapular1245373scapular
scholar1236953scholar
scimetar1244043scimetar
scimitar1243593scimitar
seculars10219393seculars
seminar979763seminar
shmear1176933shm_ear
sidebar1045563sidebar
sidecar1045233sidecar
sidler74716963si_dler
sieur5911893sieu__r
sigla64515203si_gla_
siller64026063si_ller
sima64730783sim__a_
simars84916933sim__ars
simas75727553sim__as
simian8811163sim_ian
similarly1454213similarly
simile83115633simil_e
similes92915233similes
simitars1046483simitars
simlin8311733sim_lin
simmer104115353sim_mer
simper103616293sim_per
simple104315173simpl_e
simples113014943simples
simplex18256393simplex
simply133010523simpl_y
simulacres1452533simulacres
simulacrum1661303simulacrum
simulants1144993simulants
simulated1238283simulated
simulates1139853simulates
simulators1246103simulators
simulcast1372343simulcast
singulars10305633singulars
sirdar7269103si_rdar
sitar54820543si__tar
sizar145214993si__zar
sizzler15266863sizzler
smear74416393s_m_ear
smilax1535393s_milax
smiler83916683s_miler
solar55927343s__olar
solunar735283solunar
soucar839323s_oucar
spatular1044653spatular
specular12217613specular
spicula11259293spicula_
spiculae12218603spiculae
spinula9257903spinula_
spinulae10276963spinulae
spirula9257703spirula_
spirulae10216573spirulae
spirulas10207203spirulas
sporular1065223sporular
stelar64013863s_telar
stellar72610423stellar
stimulant1145163stimulant
stimulate1148233stimulate
stimulator1245293stimulator
stimuli944513stimul_i
stimulus1044333stimulus
stylar9358113s_tylar
subalar9118073subalar
sugar6312913s__ugar
swimwear1641673swimwear
tabular9279763tabular
tegular836603tegular
templar1145643templar
tissular843813tissular
titulars845863titulars
titulary1144873titulary
tubular9267473tubular
undular837123undular
ungular836773ungular
unsimilar1152563unsimilar
uvular955563_uvular
venular1037683venular
vesicular1445473vesicular
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.466383457.1
2DLD Change Limit1340271746.66020124.2
3Display Results1741740.0602900.0
 (SQL Overall)1786911747.18624866.5
 
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.