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

158 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
biogs8501611(None) 
bigos85020011bigos
bigs76235021bi_gs
biog76122321biog_
biogas94310911biogas
bios66335321bio_s
blogs85319231blogs
bogs75742751b_ogs
bags76645502b_ags
bangs85627772bangs
befogs1246452befogs
begs75733832b_egs
beings94613032beings
bergs84718042bergs
bias64738162bi_as
bibbs84911582bibbs
bibs84830992bi_bs
bices95029962bices
bides85536772bides
bidis86721142bidis
bids75838452bi_ds
biers76225222biers
biffs134814412biffs
big67345722bi_g_
biggy124413132biggy
bigot84828322bigot
bigots95015132bigots
bijous1548042bijous
bikes117529472bikes
biles75542142biles
bilge87618912bilge
bilges94915632bilges
bilgy114713712bilgy
bilks115117892bilks
bills75632862bills
bimas95521742bimas
binds86627472binds
bines76946792bines
binge85125512binge
binges93923122binges
bingo86020092bingo
bingos95514792bingos
binocs1039922binocs
bins66548252bi_ns
bints76130182bints
bio57846082bio__
biogen9310252biogen
biogens1038962biogens
biome94916992biome
biomes103815252biomes
biont7727162biont
bionts8612392bionts
biopsy1334532biopsy
biota74516822biota
biotas84313922biotas
bipods11408592bipods
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
bis56860662bi__s
bises75435622bises
bisks115416802bisks
bisons83914372bisons
bites75641172bites
bits66148162bi_ts
bitts75022592bitts
bizes165923662bizes
blobs95620032blobs
blocs95219652blocs
blog75723822blog_
blots75626172blots
blows105423832blows
boas66150832b_oas
bobs86340652b_obs
bods76244712b_ods
bog67852412b_og_
bogus85616472b_ogus
bogy106426192b_ogy
boils75427192boils
boings96416872boings
bongs87828422bongs
boobs96221992boobs
boogy114518322boogy
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032b_oos
boots75837972boots
bops86037982b_ops
bos57966812b_o_s
boss65938342b_oss
bots66453952b_ots
bows96242862b_ows
boys96737332b_oys
brags85625102brags
brigs85823222brigs
brings94618432brings
brios74725722brio_s
broos75126412broos
bros65635662bro_s
brows105425982brows
bugs76035912b_ugs
bungs85323862bungs
buoys104810632buoys
burgs84924092burgs
cigs75625102ci_gs
cions75222852cions
clogs85519552clogs
cogs77340032_cogs
digs66036052di_gs
dings76331402dings
diols65521012diols
dogs66440152_dogs
figs85332642fi_gs
flogs95919962flogs
fogs87035002_fogs
frogs96220772frogs
gigs66631182gi_gs
grogs76319412grogs
hogs87139662_hogs
iggs66612672_iggs
ions46737852_ions
jigs126524762ji_gs
jogs127129332_jogs
kings105825562kings
lings67135772lings
lions55923212lions
logs57343112_logs
miggs96311372miggs
migs76935322mi_gs
mogs75439332_mogs
nogs56534612_nogs
pigs76634222pi_gs
pings85830882pings
pions75826392pions
pious74621272pious
progs86624152progs
rigs55137592ri_gs
rings65029172rings
riots54922012riots
shogs95319712shogs
sings65532702sings
slogs64521842slogs
smogs85112162smogs
snogs66017492snogs
tings65329202tings
togs57242432_togs
trogs67022602trogs
vigs85427272vi_gs
viols86118102viols
wigs84931252wi_gs
wings95727242wings
wogs86531402_wogs
zigs145422792zi_gs
zings154620892zings

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 Filter178691538000.313570897.8
2DLD Change Limit538001581.50035866.7
3Display Results1581580.0463434.8
 (SQL Overall)1786911581.85996122.1
 
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.