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

188 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
dirls6472050(None) 
birls74023161birls
dials64925341dials
dills65530971dills
diols65521011diols
dirks105619521dirks
dirl57430021dirl_
dirts66824461dirts
girls64518391girls
tirls54519801tirls
virls85618601virls
ails45654712ai_ls
airns55521032airns
airs46447422air_s
airts55626342airts
arils58732202arils
bills75632862bills
birds85421332birds
birks114920302birks
birl65830472birl_
birle75023632birle
birles84920642birles
biros75325132biros
birrs74917102birrs
burls74228852burls
byrls105711232byrls
carls77037422carls
cires74932912cires
curls74927102curls
dahls95012282dahls
dals57145122d_als
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
deals65435342deals
deils65722862deils
dells66630942dells
dels56745472d_els
derms85022892derms
dhals95415442dhals
dial55935062dial_
dibs76233682di_bs
dices86434242dices
dicks125824692dicks
didos76820812didos
diel59034602diel_
dies55653522di_es
diets66026642diets
diffs126315492diffs
difs86027322di_fs
digs66036052di_gs
dikes105831332dikes
dill55239972di_ll
dilly94923782dilly
dimes85833042dimes
dimly114913482dimly
dims75435022di_ms
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042di_ns
dints67431312dints
diol57329132diol_
dips75536912di_ps
diram84419472diram
dirams94413702dirams
dire56644142dir_e
direly10311562direly
direr64927072direr
direst75024242direst
dirge75117072dirge
dirges84915102dirges
dirk96326832dir_k
dirled84514902dirled
dirndls933892dirndls
dirt55550382dir_t
dirty95617802dirty
dis46459892di__s
discs85316262discs
disks105417472disks
diss56434482di_ss
ditas65923672ditas
dites66339152dites
dits56450522di_ts
divas95418582divas
dives95832402dives
dolls66126922dolls
dols56943052d_ols
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
dribs85115062dribs
dries64733672dries
drill64718262drill
drills74414202drills
drily95816522drily
drips85417232drips
drys86314802d_rys
duals65620082duals
duels65619232duels
dulls64523742dulls
duras65727732duras
dures65635922dures
durns64819872durns
duros65422692duros
durrs65519992durrs
earls56127512earls
farls85731112farls
fills84632372fills
fils75838692fi_ls
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
furls85322052furls
gills64728192gills
girds74816992girds
girl56226552girl_
girly94415292girly
girns64516802girns
giros65722652giros
girts65423622girts
harls85634502harls
herls85226432herls
hills85431352hills
hires86134342hires
hurls86522712hurls
idols65514132idols
idyls9498802idyls
ills47030422_ills
ires45639282_ires
iris45732552_iris
irks86220132_irks
jarls126120962jarls
jills125122822jills
kills94526172kills
kirks84915262kirks
kirns95315452kirns
kirs85831742kir_s
liras56021982liras
marls75535162marls
merls77423902merls
mills75435052mills
mils66045332mi_ls
mires75640882mires
mirks115122142mirks
mirs66940572mir_s
nills54926672nills
nils46132452ni_ls
nurls55519682nurls
oils46337972oi_ls
pills74130972pills
pirns76020092pirns
purls74723352purls
rials55026672rials
riels55121332riels
rills55032712rills
sials54227242sials
sills55135992sills
sires55945372sires
sirs44338332sir_s
skirls10449822skirls
swirls94010132swirls
thirls95012062thirls
tills54631712tills
tils45739612ti_ls
tires55437492tires
tirl45029922tirl_
tiros54524892tiros
twirls9478122twirls
vials85822382vials
vills86429322vills
viols86118102viols
vires84529682vires
virl76224472virl_
virus85316842virus
whirls124710532whirls
wills84528962wills
wires86034912wires
yills83921552yills
yirds96612512yirds
yirrs8469192yirrs
zills144020782zills

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.346516448.0
2DLD Change Limit538001882.07625915.2
3Display Results1881880.1101709.1
 (SQL Overall)1786911882.53270573.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.