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

120 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
doblones113676(None) 
doblons1037041doblon_s
colones96124432co_lones
debones103315112deb_ones
doblon938012doblon__
dobsons1036202dobson_s
doggones1135712doggones
oblongs1033532_oblongs
abalones1038753abalones
ambones11312683amb_ones
blokes123813883__blokes
blondes104213163__blondes
blonds95213343__blonds
bolloxes1736833bolloxes
boloney1247763bo_loney
boloneys1334503bo_loneys
bones76446533__b_ones
bowlines133211623bowlines
chalones13312173chalones
clones84526563__clones
cobles104622883cobl__es
coelomes1239293coelomes
cojones163512103co_jones
colognes11310603co_lognes
colone85425003co_lone_
colonel94213283co_lonel
colonels104210463co_lonels
colonies103620013co_lonies
colons86028683co_lon_s
colonus94413443co_lonus
condones112817393condones
cyclones1537483cyclones
daemones11209163daemones
daimones11208803daimones
dapsones1138383dapsones
debone93714783deb_one_
deboned113411633deb_oned
deboner103110483deb_oner
deboners11268113deb_oners
declines113315803declines
deplanes11311213deplanes
deplores1139533deplores
depones103717093d_epones
diobolons1243123diobolon_s
diploes101111493diplo_es
diplonts1146473diplonts
diploses111110323diploses
dobbies124113063dob_bies
dobbins12379533dobbin_s
dobies94422093dob__ies
doblas93812293dobl__as
dobros93910233dobro__s
dobson936593dobson__
dodoes85716103do_do_es
dogbanes1245433dogbanes
doggone1035683doggone_
doggoned1243883doggoned
doggoner1143873doggoner
doggonest1244593doggonest
dogvanes1344303dogvanes
doilies84017363doil_ies
doles67843753do_l__es
dollies83620983do_llies
dolloped1234983dolloped
dollops10287963dollo_ps
dolmens10388693do_lmens
dolors75115313do_lo_rs
dolours8438823do_lours
domaines11611063domaines
domines102918973do_mines
dominoes11349043dominoes
donjons1536733donjon_s
doolees83711613dool_ees
doolies83920713dool_ies
doubleness1345783doubleness
doubles103113353doubl__es
doubloons1242823doubloons
doublures1242573doublures
dourines9311373dourines
downzones22123843downzones
doyennes1244363doyennes
doylies114512573doyl_ies
drones75023433d__rones
duotones937643duotones
eobionts1043983eobionts
goblins1039243goblin_s
goboes95914443gob_o_es
gobonee1077783gob_onee
hoboes114717453hob_o_es
holloes103818193hollo_es
hormones13311173hormones
hotlines11811643hotlines
ionones7313883io_nones
lobelines1138563lobelines
nobleness1147523nobleness
nobles83319723nobl__es
oblates91913243_oblates
obliges1037143_obliges
oblong935383_oblon_g
oboes75717713_ob_o_es
oboles83815833_ob_oles
oolongs845953_oolongs
orgones81010793_orgones
orlons6411013_orlon_s
ozones1539393_o_zones
poblanos1244993poblanos
potlines10714213potlines
robles85321693robl__es
solonets838233so_lonets
solons65120023so_lon_s
someones1039063someones
sublines10315783sublines
subtones10311383subtones
subzones1947223subzones
tolanes74216313to_lanes
toplines102412563toplines
towlines112610343towlines
umbones1138013umb_ones
violones1137383violones
yobboes1445583yobbo_es

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621207.29620033.2
3Display Results1201200.0502400.0
 (SQL Overall)1786911207.79922912.0
 
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.