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

178 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
obelias927903(None) 
abelias93213561abelias
lobelias1047201lobelias
obelia8329451obelia_
abelia83114402abelia_
abelian92810642abelian
abulias93210692abulias
belgas9311712_belgas
belies84631052_belies
lobelia947212lobelia_
obeli73711932obeli__
obelise9310172obelise
obelises1039102obelises
obelisk1345192obelisk
obelisks1443442obelisks
obelism1138202obelism
obelisms1236392obelisms
obelize1838242obelize
obelizes1937512obelizes
obelus8348402obel_us
obias76116862ob__ias
abasias9711013abasias
abeles84719393abel_es
ablins8316193ab_lins
aboulias1065533aboulias
abulia83512503abulia_
acedias1039763acedias
akelas10311193akel_as
alexias14249793alexias
alias55834603__alias
anemias92512143anemias
babesias1246113babesias
balas76937213_bal_as
balsas86417523_balsas
bedims1149593_bedims
befits114711503_befits
befleas1236973_befleas
begins94415303_begins
bekiss1236373_bekiss
belay105021523_bel_ay
belays114313853_belays
beldam11410113_beldam
beldams1237053_beldams
beleap10410283_beleap
beleaps1138053_beleaps
belga8313233_belga_
belie75630383_beli_e
belied95022163_belied
belief115018603_belief
beliefs12448583_beliefs
belier84423563_belier
beliers94617383_beliers
belike124616283_belike
belive115415303_belive
belles85325993_belles
bellies94023723_bellies
bells76432163_bel_ls
belons84119413_belons
belows114614183_belows
bels66142493_bel__s
belts75931163_bel_ts
belugas1035903_belugas
bemas96424283_be_mas
berlins93216013_berlins
betas75528763_be_tas
bettas84913923_bettas
bevies114017303_bevies
bewigs1246533_bewigs
beylics1436183_beylics
beyliks1634853_beyliks
bezils1711310603_bezils
bias64738163_b__ias
blips95615783_b_lips
bliss75616913_b_liss
boccias13307193boccias
bohemias1545983bohemias
bolas74733763_bol_as
borrelias1144303borrelias
boylas113011723boyl_as
bumelias1245063bumelias
camelias12510293camelias
celiac101910433_celiac
celiacs11157893_celiacs
cerias83321983_cerias
chelas113817203chel_as
cobias104014993cob__ias
codeias103911223code_ias
coeliac1138233coeliac
dahlias1135723dahlias
delis64928543_deli_s
deltas74414823_deltas
doblas93812293dob_l_as
dulias71212743_dulias
eyelids1135943eyelids
felids103111623_felids
fellas95116963_fellas
ferias95020393_ferias
glias64618493__glias
goblins1039243gob_lins
godetias1045343godetias
heliac111010893_heliac
heliast10312073_heliast
helios94816633_helios
kelims1278913_kelims
lobefins1344823lobefins
lobeline1039963lobeline
lobelines1138563lobelines
lovelies1139893lovelies
medias93620783_medias
myelins1237353myelins
nobelium1245713nobelium
nobeliums1343893nobeliums
novellas1176343novellas
obas65730933ob___as
obeah1038993obe__ah
obeahs1135863obe_ahs
obeliscal1351953obeliscal
obelised1136173obelised
obelized2036333obelized
obentos936703obentos
obes66036833obe___s
obesity1275653obesity
obeyers1234813obeyers
obeying1336543obeying
obeys107010643obe__ys
obia67923113ob__ia_
obis66226843ob__i_s
obits74617553ob__its
oblast8613663ob_l_ast
oblige937653ob_lige
obliges1037143ob_liges
oboles83815833obol_es
oboli73712873oboli__
obols73715863obol__s
obolus8378813obol_us
obtains939163obtains
ocellar936533ocellar
ocellus935983ocellus
ocelots977233ocelots
ohias84415573o__hias
olefins1037493olefins
oleins6313523ole_ins
olios54520853o__lios
ollas54218283o__llas
omegas936973ome_gas
omelets938333omelets
oodlins83210513oodlins
operas8312453ope_ras
osetras737323osetras
otalgias944183otalgias
outlies72421993outlies
overlies112417043overlies
oxalis1339223oxali_s
oxlips1544433o_xlips
ozalids1794063ozalids
paellas9411413paellas
prelims1139823prelims
pyemias1436803pyemias
queleas1636723queleas
redias74523603_redias
relics84517903_relics
relies65036423_relies
rubellas10136123rubellas
selvas93812913_selvas
sepias83616103_sepias
sheilas1059403sheilas
sheltas10279663sheltas
stellas72813043stellas
taenias7311283taenias
telia55821143_telia_
telial65815363_telial
tenias64720073_tenias
thulias1035743thulias
toxemias1744733toxemias
uremias9249503uremias
wobblies15297233wobblies
xenias133712973_xenias
yeelins1038813yeelins

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.1561145455.1
2DLD Change Limit1340271787.22018563.3
3Display Results1781780.0602966.7
 (SQL Overall)1786911787.43624030.5
 
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.