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

212 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
birls7402316(None) 
bills75632861bills
birds85421331birds
birks114920301birks
birl65830471birl_
birle75023631birle
birles84920641birles
biros75325131biros
birrs74917101birrs
burls74228851burls
byrls105711231byrls
dirls64720501dirls
girls64518391girls
tirls54519801tirls
virls85618601virls
ails45654712ai_ls
airns55521032airns
airs46447422air_s
airts55626342airts
arils58732202arils
baals76122702baals
bails75933522bails
bairns86710872bairns
balls76236412balls
bals66354042b_als
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
bawls105719322bawls
bells76432162bells
bels66142492b_els
bergs84718042bergs
berks115423122berks
berms95323662berms
beryls11107882beryls
biali73419072biali
bialis83617162bialis
bialy105119322bialy
bialys11387912bialys
bias64738162bi_as
bibbs84911582bibbs
bible95119422bible
bibles104617642bibles
bibs84830992bi_bs
bices95029962bices
bides85536772bides
bidis86721142bidis
bids75838452bi_ds
bield84614652bield
bields94110002bields
biers76225222biers
biffs134814412biffs
bigly114814752bigly
bigos85020012bigos
bigs76235022bi_gs
bikes117529472bikes
bile66147182bi_le
biles75542142biles
bilk105824422bi_lk
bilks115117892bilks
bill67239942bi_ll
billy105525362billy
bimas95521742bimas
binds86627472binds
bines76946792bines
bins66548252bi_ns
bints76130182bints
biogs85016112biogs
bios66335322bi_os
birch124914022birch
bird76128322bir_d
birk106326862bir_k
birled94416992birled
birler85715082birler
birlers93813002birlers
biro66131212bir_o
birr66022362bir_r
birse74517402birse
birses84717732birses
birth105619872birth
births115713602births
bis56860662bi__s
bises75435622bises
bisks115416802bisks
bites75641172bites
bits66148162bi_ts
bitts75022592bitts
bizes165923662bizes
boils75427192boils
bolls75531312bolls
borals86721912borals
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
bowls106121432bowls
bras65746452b_ras
bries74942152bries
brigs85823222brigs
brill74819952brill
brills84916292brills
brims94721622brims
brins75533972brins
brios74725722brios
bris65539612b_ris
briss75824272briss
brits76433082brits
bros65635662b_ros
buhls105111802buhls
bulls75629572bulls
buras74736302buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burl64937182burl_
burly104922832burly
burns74926782burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
byres104421382byres
byrl95716012byrl_
carls77037422carls
cires74932912cires
curls74927102curls
dials64925342dials
dills65530972dills
diols65521012diols
dirks105619522dirks
dirl57430022dirl_
dirts66824462dirts
earls56127512earls
farls85731112farls
fills84632372fills
fils75838692fi_ls
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
furls85322052furls
gills64728192gills
girds74816992girds
girl56226552girl_
girly94415292girly
girns64516802girns
giros65722652giros
girts65423622girts
harls85634502harls
herls85226432herls
hills85431352hills
hires86134342hires
hurls86522712hurls
ills47030422_ills
ires45639282_ires
iris45732552_iris
irks86220132_irks
jarls126120962jarls
jills125122822jills
kills94526172kills
kirks84915262kirks
kirns95315452kirns
kirs85831742kir_s
liras56021982liras
marls75535162marls
mbiras1077152mbiras
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 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.330541487.9
2DLD Change Limit538002121.56034487.2
3Display Results2122120.0633365.1
 (SQL Overall)1786912121.95391495.6
 
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.