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

194 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
gibbon113532(None) 
gibbons1234981gibbons
gibson935121gibson
ribbon1036531ribbon
gabion93211032gabion
gaboon93211772gaboon
gibbed124512352gibbed
gibber114112862gibber
gibbet114113382gibbet
gibbing13339372gibbing
gibbose1244082gibbose
gibbous1265332gibbous
gibsons1045042gibsons
gipon84212412gi_pon
giron66118992gi_ron
ribbons1136252ribbons
ribbony1443542ribbony
abbot9318453_abbot
aboon74918703_aboon
baboon103613913baboon
bibb75819213bibb__
bibbed104712343bibbed
bibber94613573bibber
bibbing11299613bibbing
bibbs84911583bibb_s
bicron103710773bicron
bilbo95513613bilbo_
bilboa10367843bilboa
bilbos105011203bilbos
billon83713833billon
bimbo114811873bimbo_
bimbos124610523bimbos
bison75716983bi_son
bobbin93410733bobbin
bonbon10310073bonbon
boon67142173__boon
carbon104919043carbon
cibol9512023ci_bol
cion613330913ci__on
citron83112983citron
dibbed124713473dibbed
dibber114614713dibber
dibbing133110893dibbing
dibble114013843dibble
dibbuk1543503dibbuk
diobol936883diobol
diuron738573diuron
dobbin11339523dobbin
doblon938013doblon
dobson936593dobson
dubbin11329263dubbin
ebon66821103__ebon
eikon939463ei_kon
fibbed144011553fibbed
fibber134811933fibber
fibbing15339463fibbing
fibrin1138533fibrin
fibroin1246473fibroin
gabbed125216893gabbed
gabber114916603gabber
gabbing133512033gabbing
gabble113815723gabble
gabbro11114953gabbro
gabbros12124653gabbros
gabby135512953gabb_y
gabions102410053gabions
gaboons10289903gaboons
gallon73715813gallon
gambol1138223gambol
gammon1138903gammon
garcon92912483garcon
garron73113493garron
gascon9339723gascon
gib66443533gi_b__
gibbers124710983gibbers
gibbets12417723gibbets
gibe75927783gi_b_e
gibed96215963gi_bed
giber85417703gi_ber
gibers95114663gibers
gibes84422523gi_bes
gibing103712353gibing
giblet93418893giblet
gibs75529273gi_b_s
gien56330023gi__en
gigaton946343gigaton
giglot84013133giglot
gigot74023073gi_got
gimbal11228813gimbal
gin46055753gi___n
ginzo1539613ginzo_
gipons9389603gi_pons
girn56026863gi__rn
giro55828633gi_ro_
girons75014373gi_rons
giros65722653gi_ros
gismo848863gismo_
gismos957183gismos
gitano738043gitano
gittin72910553gittin
given95915283gi_ven
gizmo1756013gizmo_
gizmos1844133gizmos
glibber1235163glibber
globin9309723globin
gluon6311223g_luon
gnomon936183gnomon
goban84414073g_oban
gobbed124613883gobbed
gobbet114214443gobbet
gobbing132910703gobbing
gobble113512983gobble
goblin939503goblin
gobo76126903g_obo_
gobony1236913g_obony
gobos86219383g_obos
godson857383godson
gombo105814043gombo_
gombos114311093gombos
gonion73612833gonion
goon57236173g__oon
gorgon8310243gorgon
graben9419723graben
gribble12297273gribble
griffon1443103griffon
grison7310103grison
guenon736403guenon
guidon837373guidon
gumbo104413583gumbo_
gumbos114610873gumbos
gyron95314623g_yron
hipbone1445923hipbone
icon66922043_i_con
ikon85814953_i_kon
inborn8319143_inborn
inion54620183_inion
ion36051023_i__on
iron46728463_i_ron
jibb155816743jibb__
jibbed184810563jibbed
jibber174111243jibber
jibbing19338063jibbing
jibboom2092493jibboom
jibbs16609743jibb_s
kibbe135211973kibb_e
kibbeh17406063kibbeh
kibbes143811193kibbes
kibbi13449273kibb_i
kibbis14398473kibbis
kibble143910953kibble
libber104414013libber
limbo95614813limbo_
limbos104712143limbos
lion46334443li__on
micron103714283micron
mignon937953mignon
mikron12318503mikron
minion83416243minion
nibbed114311903nibbed
nibbing12339553nibbing
nibble103713283nibble
ninon55517383ni_non
niton55418283ni_ton
nubbin10308293nubbin
pigeon949413pigeon
pinbone1138183pinbone
pinion83815893pinion
pinon76024533pi_non
pinyon11459763pinyon
pion67235293pi__on
piston83515923piston
piton76121583pi_ton
rabbin103112303rabbin
rabboni1144803rabboni
ribband1245583ribband
ribbed114014373ribbed
ribber103515493ribber
ribbing123111953ribbing
ribboned1343973ribboned
ribby12419683ribb_y
robbin103611183robbin
sibb85921423sibb__
sibbs96211903sibb_s
simoon858063simoon
siphon1138463siphon
tiglon737923tiglon
tigon63914443ti_gon
vibrion1245253vibrion
virion9310683virion
vision9311313vision
wigeon1037223wigeon
yobbo1237873yobbo_
yobbos1335963yobbos
zircon1754953zircon

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161944.97022679.3
3Display Results1941940.0633079.4
 (SQL Overall)1786911945.40633054.2
 
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.