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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
glib7942144(None) 
gib66443531g_ib
glia56423151glia
glim76026351glim
glob76623391glob
lib57750271_lib
alb57342652al_b
alibi7514232alibi
alif76242142alif
alit46155692alit
bib77045942_bib
blab86629132blab
bleb85425222bleb
blin67228172blin
blip88322772blip
blob86027092blob
blub85324872blub
climb115413592climb
clip86924002clip
club85819472club
crib86323582crib
dib65746942_dib
drib76823262drib
fib86344272_fib
flab96628352flab
flic96223732flic
flip96324262flip
flir76422202flir
flit76539272flit
flub95721882flub
gab67155992g_ab
gain56042162gain
gait56150192gait
gamb96331842gamb
garb75332672garb
gelid74916982gelid
ghi77019882ghi_
ghis85020162ghis
gibe75927782g_ibe
gibs75529272g_ibs
gid57047262g_id
gie47149542g_ie
gig56040752g_ig
gild65526512gild
gill56336182gill
gilt56348542gilt
gin46055752g_in
gip67645362g_ip
git46266052g_it
glad65624012glad
glair65313552glair
glam76529342glam
gleba83910242gleba
glebe85016442glebe
gled65631142gled
glee55239062glee
gleg66219802gleg
glen56027202glen
gley85724652gley
glial66715432glial
glias64618492glias
glibly1236292glibly
glide74521592glide
gliff124915662gliff
glime85620192glime
glims87417672glims
glint66830182glint
glitz154916372glitz
globe84917012globe
globs85616402globs
glom75424382glom
glop76724632glop
glow85222522glow
glue55628492glue
glug66118012glug
glum75825102glum
glut56331292glut
gob68950892g_ob
grab75427612grab
grid65829612grid
grig65424772grig
grim76929422grim
grin55733722grin
grip76127022grip
grit55247242grit
grub77220082grub
guid66022822guid
ilia46026822ilia
jib125835972_jib
klik74412652klik
lab58864782_lab
li29948752_li_
libs66732762_libs
lid47453512_lid
lie38264522_lie
limb85429382_limb
lin37967372_lin
lip514755802_lip
lis37162272_lis
lit39377312_lit
lob57154462_lob
mib76946122_mib
nib56745192_nib
olio46829672olio
pleb86123812pleb
plie65127392plie
rib56848032_rib
sib56850312_sib
slab67133762slab
slid55828982slid
slim66631962slim
slip67031732slip
slit46250102slit
slob66029422slob
slub65428032slub
snib66522982snib

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298721160.82636164.6
3Display Results1161160.0333515.2
 (SQL Overall)1786911161.125158836.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.