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

218 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
birks11492030(None) 
barks115735811barks
berks115423121berks
bilks115117891bilks
birds85421331birds
birk106326861birk_
birls74023161birls
biros75325131biros
birrs74917101birrs
bisks115416801bisks
borks115727701borks
dirks105619521dirks
irks86220131_irks
kirks84915261kirks
mirks115122141mirks
airns55521032airns
airs46447422air_s
airts55626342airts
arks85936872_arks
backs135729622backs
bairns86710872bairns
balks114926292balks
banks115527902banks
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
bark106242152bark_
barky145721612barky
barms96128462barms
barns76335142barns
bars66564092bar_s
basks115621762basks
beaks115326622beaks
becks135522012becks
bergs84718042bergs
berk105929842berk_
berms95323662berms
bias64738162bi_as
bibbs84911582bibbs
bibs84830992bi_bs
bices95029962bices
bides85536772bides
bidis86721142bidis
bids75838452bi_ds
biers76225222biers
biffs134814412biffs
bigos85020012bigos
bigs76235022bi_gs
bike106532602bi_ke
bikes117529472bikes
biles75542142biles
bilk105824422bilk_
bills75632862bills
bimas95521742bimas
binds86627472binds
bines76946792bines
bins66548252bi_ns
bints76130182bints
biogs85016112biogs
bios66335322bi_os
birch124914022birch
bird76128322bir_d
birkie124110132birkie
birkies133712432birkies
birl65830472bir_l
birle75023632birle
birles84920642birles
biro66131212bir_o
birr66022362bir_r
birse74517402birse
birses84717732birses
birth105619872birth
births115713602births
bis56860662bi__s
bises75435622bises
bisk106523352bisk_
bites75641172bites
bits66148162bi_ts
bitts75022592bitts
bizes165923662bizes
blinks124613572blinks
bocks134526572bocks
boinks125211272boinks
bonks116326462bonks
books115729712books
boras75938302boras
bores76448252bores
bork106933822bork_
borts76735452borts
bosks115218852bosks
bras65746452b_ras
bricks144614622bricks
bries74942152bries
brigs85823222brigs
brims94721622brims
brinks124616312brinks
brins75533972brins
brios74725722brios
bris65539612b_ris
brisk115615982brisk
brisks124611402brisks
briss75824272briss
brits76433082brits
bros65635662b_ros
bucks134824292bucks
bulks115920612bulks
bunks115125082bunks
buras74736302buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burka114617692burka
burkas124513802burkas
burke115122762burke
burkes124421312burkes
burls74228852burls
burns74926782burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
busks115521372busks
byres104421382byres
byrls105711232byrls
carks115534212carks
chirks155414842chirks
cires74932912cires
corks116028272corks
darks106727872darks
dicks125824692dicks
dinks105927952dinks
dirk96326832dirk_
dirls64720502dirls
dirts66824462dirts
disks105417472disks
dorks105724442dorks
finks125424222finks
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
forks125324682forks
ginks104319562ginks
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
harks126333432harks
hicks145322172hicks
hires86134342hires
ilks87218572_ilks
inks86926502_inks
ires45639282_ires
iris45732552_iris
irk76426362_irk_
jerks166514892jerks
jinks165019332jinks
kicks104420082kicks
kinks84926082kinks
kirk76221572kirk_
kirns95315452kirns
kirs85831742kir_s
larks95227812larks
licks115325392licks
links96430192links
liras56021982liras
lurks95218742lurks
marks115933482marks
mbiras1077152mbiras
merks114722402merks
micks135525372micks
milks115020582milks
minks115829272minks
mires75640882mires
mirk106729502mirk_
mirky146315522mirky
mirs66940572mir_s
murks114821732murks
narks96026032narks
nicks114920492nicks
oinks94819912oinks
parks116134462parks
perks115325802perks
picks135226142picks
pinks115729382pinks
pirns76020092pirns
porks115124142porks
quirks19419112quirks
ricks115126132ricks
rinks94827102rinks
risks94917062risks
sarks96632462sarks
shirks134814122shirks
sicks115127622sicks
silks94620682silks
sinks95529182sinks
sires55945372sires
sirs44338332sir_s
smirks124910122smirks
stirks104914242stirks
ticks115823292ticks
tires55437492tires
tirls54519802tirls
tiros54524892tiros
turks95320822turks
vires84529682vires
virls85618602virls
virus85316842virus
warks127932402warks
wicks144619362wicks
winks125325432winks
wires86034912wires
works125621902works
yerks125416562yerks
yirds96612512yirds
yirrs8469192yirrs
zerks185113822zerks

Search took 3 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 Limit538002181.68631909.8
3Display Results2182180.0633460.3
 (SQL Overall)1786912182.06286659.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.