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

183 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
oblongs103353(None) 
oblong935381oblong_
oolongs845951oolongs
ablings1038742ablings
belongs10408222belongs
blogs85319232_blo_gs
blonds95213342_blonds
bongs87828422_b_ongs
doblones1136762doblones
doblons1037042doblon_s
flongs105010492_flongs
kalongs1255442kalongs
klongs11436602_klongs
longs65527062__longs
oblongly1442482oblongly
oolong738072oolong_
orlons6411012orlon_s
abalones1038753abalones
ablins8316193ablin_s
allonge837023allonge
allonges937313allonges
along65419493_along_
azlons154110423azlon_s
bangs85627773_b_angs
barongs105310833barongs
beings94613033_beings
belong93411043belong_
belons84119413belon_s
bhangs12449663_bhangs
biltongs1133813biltongs
biogs85016113_bio_gs
bionts8612393_bionts
blanks124112893_blanks
blends96012883_blends
blinds95111613_blinds
blinis85313683_blinis
blinks124613573_blinks
bloats85215763_bloats
blobs95620033_blo_bs
blocks144513943_blocks
blocs95219653_blo_cs
blog75723823_blo_g_
blokes123813883_blokes
blond85618373_blon_d
blonde94813293_blonde
blondes104213163_blondes
bloods94614843_bloods
blooms104613173_blooms
bloops106611343_bloops
blots75626173_blo_ts
blows105423833_blo_ws
bluings10327963_bluings
blunge94311483_blunge
blunges104212223_blunges
blunts84512893_blunts
bodings113711653bodings
bogs75742753_b_o_gs
boings96416873_boings
bologna1044253bologna
bolognas1144073bolognas
boloney1247763boloney
boloneys1334503boloneys
bolos75531373bolo__s
bolsons969483bolson_s
bonds86126843_b_onds
bones76446533_b_ones
bong75633413_b_ong_
bongo85720943_b_ongo
bongos95316653_b_ongos
bonks116326463_b_onks
bonus75324323_b_onus
boons75031913_boon_s
borings103614243borings
borons85520543boron_s
bosons85016653boson_s
bowings133612003bowings
bowlings14408753bowlings
boxings17429163boxings
brings94618433_brings
broncs101611153_broncs
bungs85323863_b_ungs
clangs95113613_clangs
clings95716213_clings
clogs85519553_clo_gs
clones84526563_clones
clonks125013473_clonks
clons75228133_clon_s
clonus85212413_clonus
codlings123110103codlings
cologs96517353colo_gs
colones96124433colones
colons86028683colon_s
colonus94413443colonus
cowlings14359783cowlings
doblon938013doblon__
dobsons1036203dobson_s
dongs76525813__dongs
dugongs1053253dugongs
ebons74316093eb_on_s
eobionts1043983eobionts
felons93615763felon_s
filings115213073filings
flings106715283_flings
flogs95919963_flo_gs
flong95815683_flong_
foulings12327943foulings
fowlings15377243fowlings
furlongs12304073furlongs
gloggs935033_gloggs
gobangs11385833gob_angs
goblins1039243goblin_s
godlings11367493godlings
gongs74921613__gongs
goslings10297553goslings
halons95720713halon_s
hongs95126203__hongs
kalong1177703kalong_
klong105310403_klong_
legongs934543legongs
lings67135773__lings
logs57343113__lo_gs
long56933343__long_
longe66626463__longe
longes75925573__longes
lungs65223883__lungs
melons84117713melon_s
nylons9267973nylon_s
obconic1346353obconic
oblasts947303oblasts
oblates91913243oblates
oblige937653obl_ige
obliges1037143obliges
obloquy2141873obloquy
oboes75717713ob_o_es
oboles83815833ob_oles
obols73715863ob_o_ls
obolus8378813ob_olus
obtunds1033763obtunds
odeons739023odeon_s
offings14285833offings
ogling83211883ogling_
oiling74925313oiling_
olingo736933o_lingo
olingos846013o_lingos
ology94113113o_lo_gy
onions64016433onion_s
onloads8246673onloads
oology103210253oolo_gy
orangs74116033o_rangs
orgones81010793orgones
orlon5415003orlon__
orlops847303orlo_ps
ourangs8318503ourangs
outings84014753outings
oxbloods1842753oxbloods
ozones1539393o_zones
palings103915823palings
pilings103313613pilings
plonks124210423_plonks
poblanos1244993poblanos
pongs85526343__pongs
prolongs11347613prolongs
prongs94314483_prongs
pulings103511323pulings
pylons113011243pylon_s
rollings9419953rollings
rulings83310383rulings
salons63823693salon_s
sarongs84511803sarongs
siblings11108123siblings
slangs75615343_slangs
slings74618013_slings
slogs64521843_slo_gs
solons65120023solon_s
songs67725553__songs
talons64019443talon_s
thongs104611193_thongs
throngs11508163throngs
tilings84212793tilings
tongs65928463__tongs
toolings9248473toolings
weblogs1334223weblo_gs
wrongs10338933_wrongs

Search took 7 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.390458182.1
2DLD Change Limit1340271835.83022989.2
3Display Results1831830.0632904.8
 (SQL Overall)1786911836.28328440.4
 
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.