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

173 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
gibbons123498(None) 
gibbon1135321gibbon_
gibbous1265331gibbous
gibsons1045041gibsons
ribbons1136251ribbons
gabions102410052gabions
gaboons10289902gaboons
gibbers124710982gibbers
gibbets12417722gibbets
gibbing13339372gibbing
gibbose1244082gibbose
gibson935122gibson_
gipons9389602gi_pons
girons75014372gi_rons
ribbon1036532ribbon_
ribbony1443542ribbony
abbots1039283_abbots
aiblins9311473aiblins
baboons113211083baboons
bibbers103911353bibbers
bibbing11299613bibbing
bibbs84911583bibb__s
bicrons113410473bicrons
bilboas11438733bilboas
bilboes114410243bilboes
bilbos105011203bilbo_s
billons93013363billons
bimboes13498733bimboes
bimbos124610523bimbo_s
bisons83914373bi_sons
bobbins103410343bobbins
bonbons1139333bonbons
boons75031913__boons
carbons115418943carbons
cibols1039523ci_bols
cions75222853ci__ons
citrons92913223citrons
dibbers124013173dibbers
dibbing133110893dibbing
dibbles124013333dibbles
dibbuks1643163dibbuks
diobols1036543diobols
diurons838823diurons
dobbins12379533dobbins
doblons1037043doblons
dobsons1036203dobsons
dubbins12358803dubbins
ebons74316093__ebons
eikons1038503ei_kons
fibbers144510603fibbers
fibbing15339463fibbing
fibrins1238643fibrins
fibroins1346223fibroins
fibrous1237593fibrous
gabbers124612833gabbers
gabbing133512033gabbing
gabbles124415413gabbles
gabbros12124653gabbros
gabion93211033gabion_
gaboon93211773gaboon_
gallons83015953gallons
gambols1238593gambols
gammons1237973gammons
garcons102411643garcons
garrons82713463garrons
gascons10289103gascons
gibbed124512353gibb_ed
gibber114112863gibb_er
gibbet114113383gibb_et
gibbously1772923gibbously
gibers95114663gi_bers
gibes84422523gi_b_es
gibing103712353gi_bing
giblets103210423giblets
gibs75529273gi_b__s
gigatons1046053gigatons
giglots9367863giglots
gigots83911953gi_gots
gimbals12257823gimbals
gins55543953gi___ns
ginzoes1735433ginzoes
gipon84212413gi_pon_
girns64516803gi__rns
giron66118993gi_ron_
giros65722653gi_ro_s
gismos957183gismo_s
gitanos837173gitanos
givens10379733gi_vens
gizmos1844133gizmo_s
globins10278953globins
globous1036503globous
gluons738503g_luons
gnomons1035753gnomons
gobans94412043g_obans
gobbets12327643gobbets
gobbing132910703gobbing
gobbles123512583gobbles
goblins1039243goblins
goboes95914443g_oboes
gobony1236913g_obony
gobos86219383g_obo_s
godsons966663godsons
gombos114311093gombo_s
goons65326773g__oons
gorgons938853gorgons
grabens10367003grabens
gribbles13307363gribbles
griffons1542573griffons
grisons838993grisons
guenons836563guenons
guidons936623guidons
gumbos114610873gumbo_s
gyrons105511223g_yrons
hipbone1445923hipbone
hipbones1546023hipbones
icons76516493_i_cons
ikons96311013_i_kons
inions64417003_inions
ions46737853_i__ons
irons55324133_i_rons
jibbers18449703jibbers
jibbing19338063jibbing
jibboom2092493jibboom
jibbooms21112263jibbooms
jibbs16609743jibb__s
kibbehs18354183kibbehs
kibbes143811193kibb_es
kibbis14398473kibb_is
kibbles153510253kibbles
libbers113812833libbers
limbos104712143limbo_s
lions55923213li__ons
microns113814783microns
mignons1037863mignons
mikrons13428413mikrons
minions93314623minions
nibbing12339553nibbing
nibbles114011693nibbles
ninons64913773ni_nons
niobous936333niobous
nitons64614903ni_tons
nubbins11268023nubbins
pigeons1039183pigeons
pinbone1138183pinbone
pinbones1238143pinbones
pinions93413603pinions
pinons86019943pi_nons
pinyons12299003pinyons
pions75826393pi__ons
pistons93016373pistons
pitons85319043pi_tons
rabbins112811343rabbins
rabboni1144803rabboni
rabbonis1245013rabbonis
ribband1245583ribband
ribbands1344563ribbands
ribbers113913183ribbers
ribbing123111953ribbing
ribbings13275923ribbings
ribboned1343973ribboned
robbins112811063robbins
sibbs96211903sibb__s
simoons937943simoons
siphons1239353siphons
tiglons837343tiglons
tigons74112263ti_gons
vibrions1345093vibrions
virions1039873virions
visions10311023visions
wigeons1136983wigeons
yobboes1445583yobboes
yobbos1335963yobbo_s
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.406440125.6
2DLD Change Limit1340271736.78019768.0
3Display Results1731730.0632746.0
 (SQL Overall)1786911737.24924650.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.