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

140 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
lipoma104675(None) 
lipomas1156441lipomas
diploma1295932diploma
glioma935952gli_oma
lima65734142li__ma
lipa68425932lip__a
lipoid9411042lipoid
lipomata1244562lipomata
aboma91114603_aboma
aroma71220153_aroma
bima86723843bi__ma
biome94916993bi_ome
biota74516823bi_ota
bipod104410823bipo_d
bipods11408593bipods
bipolar1145463bipolar
caeoma1039033caeoma
chroma132912473chroma
cinema1047653cinema
citola838393citola
coma87134853__coma
cupola10317693cupola
diplomas1385993diplomas
diplomat1387433diplomat
dipody1336363dipody
dipolar1056853dipolar
dipole91112853dipole
eidola737683eidola
fibroma1444123fibroma
gipon84212413gipo_n
gipons9389603gipons
gliomas1035333gli_omas
iota45127833_i_ota
ipomoea1143203_ipomoea
ixora1236913_ixora
jicama1734883jicama
kinema1236023kinema
lama66635303l__ama
lemma94811033l_emma
lepta75714393lep_ta
leucoma1144453leucoma
leukoma1343313leukoma
liana53915893li_ana
libra74712423li_bra
lido56028173lido__
lidos65219893lido_s
liftman1244063liftman
ligula7359673ligula
likuta1034213likuta
lilo46731573lilo__
lilos55821873lilo_s
liman75921603li__man
limas75627633li__mas
limb85429393li__mb
limba95414983li_mba
lime66244943li__me
limina83514503limina
limn66527703li__mn
limo65529743li__mo
limos75320813limo_s
limp88432503li__mp
limpa97014463li_mpa
limy95727723li__my
lineman939133lineman
linga66820823li_nga
lingam95112353lingam
lingua7509913lingua
linkman1335393linkman
lino46343383lino__
linos55631503lino_s
linum7313823linum_
linums838283linums
lion46334453li_o_n
lions55923213li_ons
lip514755813lip___
lipase8239103lipase
lipe66839743lip__e
lipid85916173lip_id
lipide93511063lipide
lipids94310923lipids
lipin75518893lip_in
lipins85016883lipins
lipoidal1144473lipoidal
lipoids1038233lipoids
liposomal1353033liposomal
liposome1246013liposome
lipped114419543lipped
lippen103911403lippen
lipper104219633lipper
lippy124511903lip_py
lipread1034953lipread
lips67141453lip__s
lira46928693li__ra
lirot5430033liro_t
liroth938383liroth
lissom837403lissom_
lissome937583lissome
lithia939333lithia
litoral7610763litoral
llama799893l_lama
loam65630483l__oam
loca65527683l__oca
loofa85912813l_oofa
loom67035053l_oom_
looms75124643l_ooms
lordoma1056043lordoma
lota47233503l__ota
louma76213633l_ouma
luma65527523l__uma
lupous849433lupous
lymphoma2053663lymphoma
miasma1097563miasma
mimosa1036363mimosa
minima105512653minima
myoma1239273_myoma
myxoma2043943myxoma
nipa69421643nip__a
noma67529463__noma
pima85428663__pima
pom78249913__pom_
pome85636693__pome
pomo85828453__pomo
pomp106225463__pomp
poms87037743__poms
puma85424123__puma
rhizoma2143283rhizoma
rioja1236303ri_oja
ripoff1436433ripoff
ripost83615003ripost
sapota8310213sapota
sigma84513833si_gma
sima64730793si__ma
slipout949083slipout
soma65635293__soma
stoma75918273_stoma
stroma84313073stroma
tipoff1436383tipoff
tritoma948063tritoma
viola85915543vi_ola
zygoma2143493zygoma

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161404.78023580.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911405.20234350.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.