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 “gigaton” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
gigaton94634(None) 
gigatons1046051gigatons
ligation92313092ligation
megaton10269852megaton
negaton8299142negaton
rigatoni944622rigatoni
agitation10311223agitation
agitato856573agitato_
agitator946713agitator
avigator12236773avigator
baton75822423__baton
bigaroon1144593bigaroon
citation10314363citation
citator9310123citator
craton84517193_craton
diatom939453di_atom
diatron839283di_atron
dilation92215463dilation
dilator82712783dilator
fixation1837073fixation
fugato1036223fugato_
fugatos1135483fugatos
gator64416033__gator
gelatin83514733gelatin
gelation93014433gelation
gelato73812953gelato_
gelatos83111513gelatos
gibbon1135323gi_bbon
gibson935123gi_bson
giga66720943giga___
gigabit1145403gigabit
gigaflop1551353gigaflop
gigantean1151263gigantean
gigantic1244303gigantic
gigas75415583giga__s
giglot84013133gig_lot
giglots9367863giglots
gigolo836533gigolo_
gigolos934693gigolos
gigot74023073gig__ot
gigots83911953gigot_s
gipon84212413gi__pon
girasol874623girasol
giron66118993gi__ron
gitano738043gitano_
gitanos837173gitanos
gittin72910553gi_ttin
glutton844893glutton
gratin74520583g_ratin
greaten83610643greaten
gyration1237763gyration
gyrator1135713gyrator
hightop1645013hightop
himation1339753himation
isatin6412213_isatin
jigaboo1742993jigaboo
kiloton1196313kiloton
legation92412933legation
legato72810953legato_
legator83011133legator
legatos82711183legatos
libation102411363libation
ligan67920283liga__n
ligate72519253ligat_e
ligated92414143ligated
ligates82318383ligates
ligating102212283ligating
ligations102111993ligations
lighten112811523lighten
limacon1144143limacon
megaron10248303megaron
megatons11279703megatons
mignon937953mig_non
migration12179703migration
migrator1147873migrator
misatone1049763misatone
negation92913023negation
negatons9299273negatons
negator83010673negator
negatron9335993negatron
nidation9410583nidation
niton55418283ni__ton
organon845913organon
pigeon949413pig_eon
piston83515923pi_ston
piton76121583pi__ton
rigadoon1043193rigadoon
rigatonis1044503rigatonis
rigaudon1042473rigaudon
righto104111093righto_
rogation91612053rogation
sabaton937713sabaton
sacaton938993sacaton
tighten11288973tighten
tiglon737923tig_lon
tigon63914443tig__on
viator93211833vi_ator
wigan95114393wiga__n
wigeon1037223wig_eon
zacaton1845633zacaton

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 Limit1340271006.36021073.4
3Display Results1001000.0303333.3
 (SQL Overall)1786911006.78026355.6
 
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.