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

234 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
tiglons83734(None) 
tiglon737921tiglon_
tigons74112261tig_ons
billons93013362billons
diglots9299502diglots
giglots9367862giglots
igloos738032_igloos
mignons1037862mignons
pigeons1039182pigeons
siglos7311472siglo_s
talons64019442t_alons
teflons1036542teflons
tigon63914442tig_on_
trigons84312092trig_ons
wigeons1136982wigeons
agons66423783_ag_ons
aiblins9311473aiblins
aiglets84012913aiglets
airglows1243463airglows
anglos74413913anglo_s
argons75018203arg_ons
azlons154110423_azlons
ballons93916963ballons
belons84119413_belons
bicrons113410473bicrons
biggins113410693biggins
bighorns1445253bighorns
bigos85020013big_o_s
bigots95015133big_ots
billions102211793billions
billon83713833billon_
billows123611293billows
bisons83914373bi_sons
bugloss1035893bugloss
chignons1444713chignons
cions75222853ci__ons
citrons92913223citrons
clons75228133__clons
cogons96818113cog_ons
colons86028683_colons
cotillons1144653cotillons
dialogs938103dialogs
diglot83014333diglo_t
diploes101111493diploes
diplont10311693diplont
diplonts1146473diplonts
diurons838823diurons
doblons1037043doblons
eidolons944983eidolons
eikons1038503ei_kons
epigons1048183epig_ons
etalons739073etalons
felons93615763_felons
fillos94415083fillo_s
filos86125383fi_lo_s
gallons83015953gallons
gibbons1234983gibbons
gibsons1045043gibsons
gigatons1046053gigatons
giglets93211553giglets
giglot84013133giglo_t
gigolos934693gigolos
gigots83911953gig_ots
gipons9389603gi_pons
girons75014373gi_rons
glans65125833__glans
glens66519853__glens
globs85616403__globs
gloms85219783__gloms
glops85619553__glops
gloss64319623__gloss
glows95518033__glows
gluons738503__gluons
goons65326773__goons
hagdons1258523hagdons
halons95720713_halons
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
icons76516493_i_cons
igloo6410493_iglo_o
iglus6609933_igl_us
ikons96311013_i_kons
inions64417003_inions
ions46737853_i__ons
irons55324133_i_rons
jillions15178283jillions
kilns95112983ki_l_ns
kilos95021473ki_lo_s
lagoons839253lagoons
legions84611783legions
ligans76817733lig_ans
lignans8398853lignans
lignins84010493lignins
ligroins946823ligroins
lilos55821873li_lo_s
lions55923213li__ons
logions86211293logions
logons79818173log_ons
melons84117713_melons
merlons93311273merlons
microns113814783microns
mignon937953mignon_
mikrons13428413mikrons
millions101712433millions
milos75428013mi_lo_s
minions93314623minions
ninons64913773ni_nons
nitons64614903ni_tons
nylons9267973_nylons
orlons6411013_orlons
pigeon949413pigeon_
piggins113010473piggins
piglets103311793piglets
pigpens1235503pigpens
pillions101610923pillions
pillows122610123pillows
pilots84018873pi_lots
pilous84717753pi_lous
pinions93413603pinions
pinons86019943pi_nons
pinyons12299003pinyons
pions75826393pi__ons
pistons93016373pistons
pitons85319043pi_tons
pylons113011243_pylons
raglans82410133raglans
regions83613473regions
regloss8218023regloss
reglows11288843reglows
ribbons1136253ribbons
rigors72813713rig_ors
salons63823693_salons
sigloi737743siglo_i
signors83410913signors
signs65516323sig__ns
silos56029433si_lo_s
simlins9311843simlins
simoons937943simoons
siphons1239353siphons
sirloins836723sirloins
solons65120023_solons
stolons73410243stolons
tagalong1042763tagalong
tagalongs1142233tagalongs
tagline82412453tagline
taglines92210833taglines
tailors73212393tailors
talions7314113talions
tallols73311363tallols
tallows103313743tallows
talon55824113t_alon_
tampons112711563tampons
tarpons92612213tarpons
tauons63412673t_auons
taxons134211503t_axons
teflon937453teflon_
telos55424523t_elo_s
telsons739223telsons
tendons8311473tendons
tenons62916603t_enons
testons7313563testons
tholos94213003tholo_s
thorons104511913thorons
tictocs1145903tictocs
tieless72512563tieless
tiepins939463tiepins
tiffins13327983tiffins
tigers75616513tig_ers
tightens12297953tightens
tights104015853tig_hts
tigress836093tigress
tilaks1097353ti_laks
tildes74513963ti_ldes
tilers63523503ti_lers
tiles55542103ti_l_es
tiling73426553ti_ling
tilings84212793ti_lings
tillers73418743tillers
tilling83522783tilling
tills54631713ti_l_ls
tils45739613ti_l__s
tilths9459373ti_lths
tilts55325613ti_l_ts
timeous938403timeous
timolols1044333timolols
tinglers93710593tinglers
tingles83818323tingl_es
tingling102210823tingling
tinhorns1145013tinhorns
tins45251303ti___ns
tipless92610063tipless
tiptoes939173tiptoes
tiptops1136073tiptops
tirling83315733tirling
tirls54519803tirl__s
tiros54524893ti_ro_s
titans63414913ti_tans
titians72710453titians
titles63719923titl_es
titling83715793titling
tolans64319273t_olans
tons46553053t___ons
toons55027533t__oons
toyons95512133t_oyons
trigon74513103trig_on_
trigos74214173trig_o_s
trillions947183trillions
tritons73814883tritons
trogons83410723trogons
tugless837383tugless
tuitions838283tuitions
turions7311573turions
turnons737863turnons
twigless1293663twigless
tycoons1235173tycoons
typhons1537083typhons
vigors102911483vig_ors
villous102810023villous
violins10311453violins
violone1037153violone
violones1137383violones
virions1039873virions
visions10311023visions
waggons1235503waggons
wagons103911213wag_ons
widgeons1343853widgeons
wigans104511703wig_ans
wigeon1037223wigeon_
wigless11359673wigless
wiglets113411423wiglets
willows13299753willows
zillions17168073zillions
zircons1854963zircons

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.436409841.7
2DLD Change Limit1340272347.26618445.8
3Display Results2342340.0932516.1
 (SQL Overall)1786912347.79522923.8
 
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.