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

151 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
gibsons104504(None) 
gibbons1234981gibbons
gibson935121gibson_
bisons83914372bi_sons
dobsons1036202dobsons
gabions102410052gabions
gaboons10289902gaboons
gibbon1135322gibbon_
gibbous1265332gibbous
gipons9389602gi_pons
girons75014372gi_rons
godsons966662godsons
grisons838992grisons
ribbons1136252ribbons
aiblins9311473aiblins
arsons63917213_arsons
baboons113211083baboons
bicrons113410473bicrons
billons93013363billons
bison75716983bi_son_
bolsons969483bolsons
boons75031913__boons
bosons85016653_bosons
caissons1036283caissons
cibols1039523cib_ols
cions75222853ci__ons
citrons92913223citrons
crimsons1245633crimsons
damsons1038013damsons
dipsos95310053dipso_s
disowns1136733di_sowns
diurons838823diurons
doblons1037043doblons
dobson936593dobson_
ebons74316093_eb_ons
eikons1038503ei_kons
fibrins1238633fibrins
fibroins1346213fibroins
fibrous1237593fibrous
fissions1138033fissions
foisons1047613foisons
frissons1145043frissons
gabion93211033gabion_
gaboon93211773gaboon_
gallons83015953gallons
gambesons1442343gambesons
gammons1237973gammons
garcons102411643garcons
garrons82713463garrons
gascons10289103gascons
gessoes838293gessoes
gibbers124710983gibbers
gibbets12417723gibbets
gibbing13339373gibbing
gibbose1244083gibbose
gibers95114663gib_ers
gibes84422523gib__es
gibing103712353gib_ing
giblets103210423giblets
gibs75529273gib___s
gigatons1046053gigatons
giglots9367863giglots
gigots83911953gi_gots
gins55543953gi___ns
ginseng933433ginseng
ginsengs1042653ginsengs
ginzoes1735433ginzoes
gipon84212413gi_pon_
gipsies1039903gipsies
girasols984273girasols
girns64516803gi__rns
giron66118993gi_ron_
giros65722653gi_ro_s
girosols984653girosols
girshes11248293girshes
gismos957183gi_smos
gists66026193gi_s_ts
gitanos837173gitanos
givens10379733gi_vens
gizmos1844133gizmo_s
gluons738503g_luons
gnomons1035753gnomons
gobans94412043gob_ans
goblins1039243goblins
goboes95914443gob_oes
gobony1236913gob_ony
gobos86219383gob_o_s
godson857383godson_
goons65326773g__oons
gorgons938853gorgons
gossans836783gossans
gossoons944893gossoons
griffons1542573griffons
grison7310103grison_
guenons836563guenons
guidons936623guidons
gyrons105511223g_yrons
hysons1237633_hysons
icons76516493_i_cons
ikons96311013_i_kons
inions64417003_inions
ions46737853_i__ons
irons55324133_i_rons
kelsons1137323kelsons
lessons73811023lessons
liaisons844293liaisons
lions55923213li__ons
masons83916513_masons
mesons83215843_mesons
microns113814783microns
mignons1037863mignons
mikrons13428413mikrons
minions93314623minions
misos76523293mi_so_s
missions10311903missions
nelsons738003nelsons
ninons64913773ni_nons
nitons64614903ni_tons
orisons7310563orisons
parsons93516873parsons
persons93717013persons
pigeons1039183pigeons
pinions93413603pinions
pinons86019943pi_nons
pinyons12299003pinyons
pions75826393pi__ons
pisos76021063pi_so_s
pistons93016373pistons
pitons85319043pi_tons
poisons9310353poisons
prisons9313223prisons
ramsons939563ramsons
reasons72514943reasons
ribbon1036533ribbon_
ribbony1443543ribbony
riboses9310443riboses
seasons72614233seasons
simoons937943simoons
siphons1239353siphons
sons46049553___sons
telsons739223telsons
tiglons837343tiglons
tigons74112263ti_gons
unisons748423unisons
vibrions1345093vibrions
virions1039873virions
visions10311023visions
visors92912223vi_sors
weasons102310583weasons
wigeons1136983wigeons
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 Limit1340271516.79619721.5
3Display Results1511510.0503020.0
 (SQL Overall)1786911517.25224640.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.